Video:Quick Tip: How to Freeze and Unfreeze Panes in Excelwith Nicholas J. Saccomanno
Freeze and unfreeze panes in excel spreadsheets so that you can keep track of each column and row. Watch this About.com video to see how easy it is to use the Freeze setting in excel.See Transcript
Transcript:Quick Tip: How to Freeze and Unfreeze Panes in Excel
Hello. This is Nicholas J. Saccomanno for About.com and today we’ll take a look at how to freeze and unfreeze panes in Excel.
Why use Freeze Panes?
As you scroll through a large worksheet, you may find it frustrating to lose your column headings as you go down the page. With several columns of data, it can make for a confusing worksheet. To preserve the headings as you scroll down the page, you can utilize a feature called Freeze Panes.
Freeze and Unfreeze Panes
To do that, first left-click in the cell just below the heading. Then navigate to the View tab on the ribbon and select the dropdown called Freeze panes and then choose the first option, Freeze Panes. Now as you scroll through the worksheet, your headings will remain. To unfreeze these panes simply head back to the Freeze Panes drop down and this time choose Unfreeze Panes. These simple commands can help you customize how you view your worksheets.
For more information, you can visit About.com.