Using Freeze Panes Function In Excel To Improve Your Navigation

Excel spreadsheets (.xls)

If you want to learn Excel, keep reading or Get 10 days of free unlimited access to for professional help and Excel Tutorials

For many of you, working with large sets of data presents many challenges and today I thought I’d give you one way to make life much easier. Here is an example that probably occurs on a regular basis. Look at this spreadsheet:

It’s quite easy to work with this of course. But what if you have thousands of lines and you end up going further down you’d get:

If you add a few columns, you’ll end up with a problem that you’ve probably encountered in the past. You’re stuck going back to line 1 all the time to figure out which column means what.

There Is A Better Way

In such a case, what you do is simple. If you’re looking to always keep that first line visible, you can select cell A2 as follows:

Then, you’d select the menu folder and click on freeze panes:

As you can imagine, either of these 2 options would work:

As you can see, no matter where I go in that sheet, I will still see that first line (with the column headers). The same can be done for a column, etc.


Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss



Please Leave a Comment!

Please note: Comments may be moderated. It may take a while for them to show on the page.