Quick Tip: How to Freeze and Unfreeze Panes in Excel Video
  1. Tech

Your suggestion is on its way!

An email with a link to:


was emailed to:

Thanks for sharing About.com with others!

Video:Quick Tip: How to Freeze and Unfreeze Panes in Excel

with 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.

About videos are made available on an "as is" basis, subject to the User Agreement.

©2015 About.com. All rights reserved.