Manage Worksheets and Workbooks
Structure, views and print control
This domain is about controlling workbook structure, not cell content. Be fluent with inserting, deleting, renaming, moving, copying and colour-coding tabs; selecting several sheets to group them; hiding and unhiding sheets; and switching among Normal, Page Layout and Page Break Preview views. Know the difference between Freeze Panes, which locks rows or columns so they stay visible while the rest scrolls, and Split, which cuts the window into independently scrolling panes. View > New Window opens a second window on the same workbook, useful for comparing distant ranges.
Page setup is tested heavily: margins, orientation, scaling (fit to pages), print area, manual page breaks, headers and footers, centring on the page, and especially Print Titles, which repeat chosen rows or columns on every printed page and must be set for each worksheet separately.
Traps exam writers like
- Grouped sheets: typing, formatting, or filling while tabs are grouped applies to every selected sheet. Click one tab to ungroup before editing.
- A sheet can be hidden from the tab shortcut menu, but a very hidden sheet can only be revealed through the Visual Basic Editor, not the Excel UI.
- Dragging a tab moves it; holding Ctrl while dragging copies it, and the copy keeps references to the original sheet's name.
- Custom views cannot be created in a shared workbook.
Rule of thumb
To duplicate a sheet faithfully, right-click the tab > Move or Copy > tick Create a copy. Building a new sheet and pasting into it often loses column widths, print settings and page breaks.