Freeze Panes

Freeze Row

  1. Select the cell in column A just below the row you want to freeze.
../../../_images/img_01.en200.png
  1. Right-click cell, and then select 'Freeze Panes' menu.
../../../_images/img_02.en184.png

Tip

After freezing the row, that row will remain visible when the sheet is scrolled vertically.

../../../_images/img_03.en147.png

Freeze Column

  1. Select the cell in the first row and right next to the column you want to freeze.
../../../_images/img_04.en130.png
  1. Right-click cell, and then select 'Freeze Panes' menu.
../../../_images/img_05.en117.png

Tip

After freezing the column, that column will remain visible when the sheet is scrolled horizontally.

../../../_images/img_06.en94.png

Freeze row and column

  1. Select the cell below the rows and right of the columns that you want to keep visible when you scroll.
../../../_images/img_07.en87.png
  1. Right-click cell, and then select 'Freeze Panes' menu.
../../../_images/img_08.en82.png

Tip

After freezing the rows and columns, those rows and columns will remain visible when the sheet is scrolled horizontaly and verticaly.

../../../_images/img_09.en71.png

Unfreeze Rows and Columns

  1. Right-click cell, and then select 'Unfreeze Panes' menu.
../../../_images/img_10.en62.png

Tip

Within the same sheet, you can unfreeze rows and/or columns by selecting 'Unfreeze Panes' menu.