Close
Time left to register for Excel Made Easy class

Freezing Panes to Make Your Life Easier

Freezing panes will make your life a whole lot easier.

Anytime you have a spreadsheet that is too big to fit on one screen, you have a problem. When you scroll down, you can’t see the column headers. And when you scroll to the right, you can’t see the row labels.

You end up having to scroll back and forth so you know where you’re entering data.

This is confusing, frustrating, a big waste of time, and often leads to errors as you enter data in the wrong cell.

But there’s an easy solution to this: Freezing panes.

Simply click in the cell below and to the right of your label rows and columns.

Freezing panes - Where to click

Then go to the View ribbon, select the Freeze Panes drop-down, then Freeze Panes.

Freezing panes - button location

This will keep your label rows and columns visible as you scroll.

Freezing panes - result.
Note that columns A and B, and rows 1 and 2, are still visible. Even though I’ve scrolled to look at columns starting with T and rows starting with 42.

And that’s it!

Be sure to check out our blog post/video on Filters: Excel’s Easy Button.

Leave a Reply