411 How to freeze panes in Excel

Print Friendly, PDF & Email

Today I’ll show you how to make Excel easier to use for certain situations.



Sometimes a spreadsheet can have columns that are quite long. In fact, you might have to scroll to get to the bottom of some of the columns.

So when you’re at the bottom of the column, what if you need to know which column you’re looking at? You have to scroll back up to the top of the spreadsheet just to read the column name. This is not only annoying, it’s a really inefficient use of your time when you have to scroll up and down all the time.

But there is a solution!

The fix for this problem is an Excel function called Freeze Panes.

With your spreadsheet open, click on the View tab on the top.

Then go over and click on the icon that says Freeze Panes:

Excel Freeze Panes


When you click that, you’ll see 3 options come up – you can freeze the top row, or you can freeze the first column, or you can freeze both:

Excel Freeze Panes


For me, it’s the top row that I usually want to freeze. Just try one of them as an experiment.

Now, you can see that as you scroll down those long columns, the first row – the one that usually contains the NAME of that column – stays visible. No more scrolling up and down to see what column you’re looking at!

Share this post