How to Use Freeze Panes in Microsoft Excel

Having long entries of data is what Excel was made for. However, it can cause confusion when you have large tables of data that can take some time to scroll to find the right information. Freeze Panes helps you keep track of categories as you scroll.

Freeze Panes works best when using a table or spreadsheet with large amounts of data, such as one that takes quite a few scrolls to get even halfway, or where it is organized into certain categories, with headers or titles listed in a first column or row. 

To Freeze the Top Row

Go to the View tab. Select Freeze Panes >Freeze Top Row.


The top row will now stay at the top as you scroll down.

To Freeze the First Column

Go to the View tab. Select Freeze Panes > Freeze First Column.

The first column will now stay to the right as you scroll across.

Freeze Manually

You can easily use the above two buttons to freeze rows and columns. It can also be done manually. First, select one cell below the row you would like to be frozen. For columns, select one square next to the column you want frozen.


Then select Freeze Panes > Freeze Panes.


This comes in handy when you are trying to freeze data more than just the first row or column, as seen below.

Unfreeze Panes.

Whenever you are finished with the frozen panes, you can unfreeze them to return the spreadsheet to default view.

Select Freeze Panes > Unfreeze Panes.


That's it.

Congratulations! You now know who to use Freeze Panes. This will help you navigate large spreadsheets more easily.

Rate this article:
No rating

NH Learning SolutionsDebra Novara

Other posts by NH Learning Solutions

Contact author
Please login or register to post comments.

Theme picker

Contact author


Blog Search