Skip to main content

Freeze rows, colums

You can freeze rows or columns to keep them fixed when scrolling.

Freeze rows or columns​

  1. Select adjacent rows or columns.
  2. In the context menu of the row or column header, select Freeze horizontally or Freeze vertically.

You can also use the Freeze tool on the Page layout tab to:

  • Freeze first row.
  • Freeze first column.
  • Freeze selected rows and columns.
  • Freeze area.
  • Unfreeze all.