Freeze Panes in Excel Tutorial

Freezing Panes

If you have a large number of rows or columns in your Microsoft Excel Sheet, often when you scroll down or right to access the data, the headings can get hidden. MS Excel offers a perfect solution to overcome this problem with an option of freezing panes. Freezing panes let you select the headings that as locked as you scroll down or left in your worksheet.

Using Freeze Panes

You can use this option to free panes by following the steps below:

  • First of all you need to select a particular row or column (usually the first row or column containing the headings) that you wish to freeze.
  • Select the option of “Freeze Panes” listed under the View Tab.
  • On clicking the option, you will get following three options listed in the drop down list.
  • Freeze Panes: This option freezes the selected row or column.
  • Freeze Top Row: This option automatically freezes the first row from the top.

Freeze First Column: This option automatically freezes the first column from the left.

  • On freezing the top row with this option, the first row will continue to appear even when you scroll down as shown in the screenshot below.

Unfreeze Panes

If you wish to unfreeze the frozen Panes, just select the row or column and click on “Unfreeze Panes” listed under View Tab.