Excel: Freeze Panes

Freeze panes is a great feature to use with larger worksheets.  It locks down the titles on the screen, allowing you to scroll through the data area with the titles always showing.  This feature also goes very nicely with the Print Titles feature.

For this example I am going to show how to lock down the title rows, this feature can also lock down column titles or do both rows and titles.

Start by opening your worksheet.

1.  Click the mouse below the title row.  In this example it would be cell A6.

 

2.  Click on the View tab, and choose Freeze Panes.

 

 

 

3.  The Freeze Panes drop list appears.

 

 

 

 

 

 

4.  For this example choose Freeze Top Row.  And now rows are frozen.  Try scrolling down your worksheet and note that rows 1-5 stay fixed on the screen.

 

To Turn Off the Freeze Panes feature, just click Freeze Panes button again, and click on Unfreeze Panes.

 

Microsoft Excel , , , , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *