Freeze panes, split the window and zoom
Updated November 17, 2026
Freeze rows and columns
- Choose View › Freeze panes.
- Pick Freeze top row, Freeze first column, or Freeze panes to freeze the rows above and the columns to the left of the active cell.
- Choose it again to unfreeze.
Split the window
- Click a cell and choose View › Split to scroll two or four parts of the sheet on their own. Choose Split again to remove it.
Zoom and show
- Zoom in and Zoom out are on View.
- At the bottom right, the status bar has − (zoom out), a slider from 10% to 400%, + (zoom in) and the zoom level.
- Click the zoom level to open Zoom: pick 200%, 100%, 75%, 50% or 25%, Fit selection to make the selected cells as large as fits in the window, or Custom and type a zoom from 10% to 400%. Then choose OK.
- Gridlines turns the cell lines on or off. Formulas shows formulas instead of results (Ctrl+`).
- Normal, Page Break Preview and Page Layout show the sheet as cells, as printed pages with their breaks, or as pages with margins.