A Quick Excel Tip – Make Your Life Easier in 2022

Posted by Colleen Ludgate on Monday, Mar 7th, 2022
Category : Microsoft Excel

A Quick Excel Tip – Make Your Life Easier in 2022

Have you noticed how when you have a lot of data to input into one Excel spreadsheet, while scrolling down, your column headings disappear off the top of your screen? Then, you would scroll all the way back to the table headings to make sense of what you’re looking at.

There is a quick Excel tip and a simple way around this. It is the Freeze Panes feature.

Go to the View tab and toward the middle you will see Freeze Panes. Mouse over the button and the following choices will appear:

quick excel tip 1
If your column headings are in the top row then you can simply use the Freeze Top Row option, or if you want to freeze the first column instead there is an option for that too. To freeze a custom set of rows or columns simply select the area you want to freeze first, then hit the first option “Freeze Panes”.

Now when you scroll or add new rows you will always know where to put your new data!

quick excel tip 2
When you are done with your inuts and this setup you can reverse the process and put Excel back into its normal state by Unfreezing the panes:

quick excel tip 3

Summary

Freezing panes is one of those “obvious when you know how” features that come in real handy when you know it is there!

P.S.

Don’t forget to check out our PDF to Excel Converter plans. It can save you a lot of precious time and improve your productivity. The free trial is not time-limited, you can test it as long as you wish – Click here.

Latest From Our Blog