Freeze panes

Updated: 12/01/2019 by Computer Hope
Freeze panes

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, even as you navigate the spreadsheet. 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 freeze panes in Microsoft Excel 2010 and later

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

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

How to freeze rows or columns in Google Sheets

Google Sheets
  1. Open the spreadsheet.
  2. In the menu bar, click View.
  3. Select the Freeze menu option.
  4. Select the freeze option you want to use use. For example, choose 1 row to freeze the top row.
Tip

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

How to freeze rows or columns in LibreOffice Calc

LibreOffice Calc
  1. Open the spreadsheet.
  2. In the menu bar, choose View.
  3. Move your mouse down to Freeze Cells to view the freeze options.
  4. Choose either Freeze First Column or Freeze First Row.
Tip

When a row or column is frozen, a checkmark appears in the View→Freeze Cells menu, next to the option Freeze Rows and Columns. You can select this option to toggle whether your row or column is frozen.

How to freeze panes in versions of Excel before 2010

Excel older versions
  1. Open the spreadsheet.
  2. Using your mouse, highlight the entire row or column you want to freeze. For example, if you want to freeze row 1, click its row header on the left to select the entire row.
  3. 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 steps above.

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