Skip to main content

Freeze Panes

Updated

Freezing panes locks certain cells in place while allowing other cells to be scrolled through, allowing you to view and edit large amounts of data while keeping the titles on screen.

Freeze Top Row

Perform the following to freeze top row only.

  1. Click View and then Freeze Panes-Freeze Top Row.
  2. Click View and then Freeze Panes-Freeze Top Row to unfreeze the top row.

Freeze Panes

Perform the following to freeze the cell where is selected.

  1. Select a cell where you want to freeze.
  2. Click View and then Freeze Panes-Freeze Panes.
    Or click the Freeze Panes icon_freeze.png icon on the toolbar.
  3. Move over to the cells to check the cells are well frozen cells. The frozen cells are always displayed on screen.

More Information

Submenu of Freeze Panes

Menu Description
Freeze Top Row Set a freeze to the top row regardless of the selected cell.
Freeze First Column Set a freeze to the first column regardless of the selected cell.
Freeze Panes Set a horizontal/vertical freeze to the left and top of the selected cell.
Unfreeze Panes Unfreeze set panes.

Related articles