22 min read

Freeze Panes and Zoom

Keep column headings visible while you scroll, and zoom the grid for comfortable data entry.

Why Freeze and Zoom Matter

By the time Budgets grows to annual totals, contingency, and status columns, row 1 scrolls off screen. Freeze Panes locks selected rows or columns so they stay visible while the rest of the worksheet scrolls. James Okonkwo scrolls down NorthgateBudget.xlsx to check Arts Q4 in a long layout. Freeze Top Row keeps Department and Q1-Q4 visible while editing lower rows. Zoom changes display only — it does not change cell values or printed size. Page Layout \to Scale controls print scale.

Open the Budgets sheet. Click the View tab on the Ribbon. In the Window group, click Freeze Panes, then Freeze Top Row . Scroll down — row 1 stays fixed at the top. Expected result: Headers Department, Q1 (£) \dots stay visible. Row 2 (English) scrolls away but labels do not.

If department names are in column A and you scroll right past quarterly columns, use View tab \to Freeze Panes \to Freeze First Column . Scroll right — column A (Department) stays visible. This is useful when Annual Total, With contingency, and Status extend the sheet to column K .

For a large Expenses log with many columns, click cell B2 (the cell below and right of the corner you want fixed). Then View \to Freeze Panes \to Freeze Panes (the first menu item, not the sub-options). Row 1 and column A stay fixed — ideal when James Okonkwo scrolls both down and right through purchase history. To remove locks before sharing a file where colleagues expect normal scrolling: View \to Freeze Panes \to Unfreeze Panes .

On the View tab, click Zoom (or drag the status bar slider at bottom right). Choose 120% for easier reading on a laptop during data entry. Choose 100% before judging print layout. Example: Science Q4 is 19000 in cell E4 . At 120% zoom the figure is easier to read on a 13-inch screen; the stored value and =SUM(B4:E4) are unchanged. Do not confuse zoom with print scale. You zoom to 80% to fit columns on screen, then print — the paper copy is still too wide. Use Page Layout \to Scale to Fit \to Width: 1 page for printing. Use View \to Zoom for on-screen comfort only. Ctrl+mouse wheel (Windows) or Pinch on a trackpad zooms quickly without opening the Zoom dialog.

Practice

Which tab contains Freeze Panes?

Why Freeze and Zoom Matter

By the time Budgets grows to annual totals, contingency, and status columns, row 1 scrolls off screen. Freeze Panes locks selected rows or columns so they stay visible while the rest of the worksheet scrolls. James Okonkwo scrolls down NorthgateBudget.xlsx to check Arts Q4 in a long layout. Freeze Top Row keeps Department and Q1-Q4 visible while editing lower rows. Zoom changes display only — it does not change cell values or printed size. Page Layout \to Scale controls print scale.

Freeze Both Headers (Custom)

For a large Expenses log with many columns, click cell B2 (the cell below and right of the corner you want fixed). Then View \to Freeze Panes \to Freeze Panes (the first menu item, not the sub-options). Row 1 and column A stay fixed — ideal when James Okonkwo scrolls both down and right through purchase history. To remove locks before sharing a file where colleagues expect normal scrolling: View \to Freeze Panes \to Unfreeze Panes .

Zoom

On the View tab, click Zoom (or drag the status bar slider at bottom right). Choose 120% for easier reading on a laptop during data entry. Choose 100% before judging print layout. Example: Science Q4 is 19000 in cell E4 . At 120% zoom the figure is easier to read on a 13-inch screen; the stored value and =SUM(B4:E4) are unchanged. Do not confuse zoom with print scale. You zoom to 80% to fit columns on screen, then print — the paper copy is still too wide. Use Page Layout \to Scale to Fit \to Width: 1 page for printing. Use View \to Zoom for on-screen comfort only. Ctrl+mouse wheel (Windows) or Pinch on a trackpad zooms quickly without opening the Zoom dialog.

Practice

Which tab contains Freeze Panes?