Excel: Frozen

Freezing panes is a basic tool to make a large spreadsheet easier to work with. In my social media spreadsheet I like to freeze the header row into position. Then no matter how far I scroll down the sheet, the columns are labelled.

To turn on frozen panes, select the cell below the row & column you wish to freeze into position. Since I don’t want to freeze any columns, I select cell A2.

Freezing Panes using the Active Cell position" width
Freezing Panes using the Active Cell position” width

Select the View Ribbon, Click on the Freeze Panes button, and choose Freeze Panes (or Freeze Top Row in this scenario).

Freezing Panes Results
Freezing Panes Results

Now you can scroll for hundreds of rows, and each column is nicely labelled – no guessing!


This post is originally from 2016. If you want help with the newest and classic features in Excel drop me a line at catharine@mytechgenie.ca

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.