Arrange Worksheets
This button on the View tab allows you to open another instance of the same workbook, enabling you to compare worksheets side by side.
What is the New Window button?
Before protecting a worksheet, you must unlock these cells if you want users to keep editing them.
What are the data entry area cells?
This button on the Data tab is used to group rows or columns, allowing you to collapse and expand worksheet data for easier viewing.
What is the Group button?
This feature in Excel checks a workbook for hidden data or personal information before sharing it with others.
What is Inspect Document?
Before sharing a workbook with users on older versions of Excel, you should use this feature to identify potential issues with data and functionality.
What is the Compatibility Checker?
To compare the U.S. and Canada worksheets in IL_EX_6_Revenue, Elena uses this option from the Arrange Windows dialog box to place the windows next to each other.
What is the Vertical arrangement?
Protecting a workbook's structure prevents users from doing actions like deleting, renaming, or hiding these.
What are worksheets?
These symbols appear next to grouped data in a worksheet and allow you to collapse or expand detailed information.
What are outline symbols?
To help others search for and identify your workbook, you can add these descriptive terms, also known as metadata, to the file's properties.
What are Keywords (Tags)?
Excel 97-2003 versions have a limit of this many columns, causing data beyond this point to create compatibility issues.
What is 256 columns?
After comparing worksheets, you can use this button in the Window group to make one instance of a workbook temporarily invisible.
What is the Hide button?
To fully secure worksheet protection, you can add this in the Protect Sheet dialog box to prevent unauthorized changes.
What is a password?
In a grouped worksheet, clicking the Level 1 outline symbol collapses all details and shows only these.
What are the totals or summary rows?
To discourage unauthorized changes, you can mark a workbook with this status, making it read-only.
What is Mark as Final?
A "Significant loss of functionality" warning appears in the Compatibility Checker when this type of problem occurs.
What is loss of data or workbook features?
When viewing worksheets side by side, activating this feature keeps both worksheets scrolling together.
What is Synchronous Scrolling?
This button on the Review tab allows you to create specific ranges where users can make edits, even on a protected sheet.
What is the Allow Edit Ranges button?
When multiple worksheets are grouped, entering data into one sheet applies the same changes to all grouped sheets. You know worksheets are grouped because the title bar shows this word.
What is Group
Even if a workbook is marked as final, clicking this button allows you to remove read-only status and make edits.
What is Edit Anyway?
To preserve formatting and make a workbook difficult to edit, you can export it as one of these file types from the Export pane.
What is a PDF or XPS document?
To divide a worksheet into sections that scroll independently, you can select a cell and click this button on the View tab.
What is the Split button?
if you want certain rows or columns to stay visible while scrolling, you can use this feature found in the View tab.
What is Freeze Panes?
To make sure all worksheet columns fit on one page when printing, you select this option under Settings on the Print menu.
What is Fit All Columns on One Page?
You can add visual appeal to your worksheet by inserting one of these through the Page Layout tab.
What is a worksheet background image?
Instead of scrolling, you can jump directly to a specific cell like LL1 using this feature on the Home tab.
What is Go To?