Freeze panes

Updated: 11/13/2018 by Computer Hope

Freeze panes is a feature in spreadsheet applications, such as Microsoft Excel, LibreOffice Calc, and Google Sheets. It "freezes" a row or column, so that it is always displayed in place, regardless of what part of the spreadsheet is being displayed. When the user scrolls vertically or horizontally through an open spreadsheet, everything scrolls except the frozen row or column. Freezing panes is especially useful if your spreadsheet has a header row, that you want to always be visible.

How to use the freeze panes feature

Microsoft Excel 2010 and higher

  1. Open the spreadsheet.
  2. Click View.
  3. In the View tab, click Freeze Panes and select the freeze option you want to choose. For example, choose Freeze top row to freeze the top row.

Earlier versions of Microsoft Excel and other spread sheet programs

  1. Open the spreadsheet.
  2. Using your mouse, highlight the entire row or column. For example, if you wanted to select row 1, click the row header 1.
  3. Finally, select the Freeze pane option in the menu bar and choose the appropriate option.
Tip

You can also unfreeze the row or column by repeating the above steps.

Frozen, Microsoft Excel, Software terms, Spreadsheet, Spreadsheet terms