Excel Tip Tuesday: Freeze Panes

Posted by Lisa on June 26, 2018 at 10:00 AM

Excel IconDo you waste time scrolling in Excel? Do you ever have so much data in Excel that, when you scroll down or to the right, you lose the headers and have to scroll back up to see what the column heading is? You can prevent all the extra scrolling by doing one little trick in Excel called Freeze Panes, which allows you to scroll and keep the first rows or columns visible at all times.

One of the first things I do when working in any Excel file is use Freeze Panes. It makes a much nicer presentation when sharing your report, and it saves time by not having to constantly scroll.

On the View tab in Excel you, can select the Freeze Panes button, which presents you with three options: 1 - 'Freeze Panes',  2 - 'Freeze Top Row', or 3 - 'Freeze First Column'.

Excel Tips - Freeze Panes1

I almost always use the first option. If you put your cursor in the first cell that you want the scrolling to start and then select 'Freeze Panes', it will keep the rows above that cell and the columns to the left of that cell visible at all times.

Here’s what happens without Freeze Panes. There’s no way to know what 62,874.96 in cell K15 means:

Excel Tips - Freeze Panes2

Here’s what it looks like with Freeze Panes. You can see that K15 is Total Revenue for July:

Excel Tips - Freeze Panes3

So freeze those panes, and stop wondering what your data means!

Leave us a comment and let readers know what Excel tips you use on a daily basis.

Topics: Excel

Don't Miss a Thing!

Subscribe to our blog

Subscribe to our blog

    Recent Posts

    Posts by Topic

    see all