Freeze panes, split the window and zoom

Updated November 17, 2026

Freeze rows and columns

  1. Choose View › Freeze panes.
  2. 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.
  3. 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.

Was this article helpful?