Freezing or unfreezing worksheet panes typically involves multiple mouse clicks, but I'll show you a way to carry out this task with a single keystroke. For the uninitiated, freezing panes allows you to lock in place columns or rows that you specify along the left-hand and/or top of Excel's worksheet area. As you scroll to the right or down, the frozen columns or rows remain in place so that you can always view worksheet headings or the initial columns. When you no longer need the rows or columns locked in place, you in turn can unfreeze them.
To carry out this task in Excel 2007 and later, as shown in Figure 1, first click on the worksheet position you wish to freeze. Next, go to the View tab, click on Freeze Panes, and then make a selection from the submenu, such as Freeze Panes.
About David Ringstrom, CPA
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. His mantra is “Either you work Excel, or it works you.” David offers spreadsheet and database consulting services nationwide.