How to Use the Freeze Pane Command in Excel to Create Static Headings

Keep row and column labels visible as you scroll through a spreadsheet with the Freeze Pane command. These instructions are for Microsoft Excel 97.

Instructions

Difficulty: Moderately Easy

Things You’ll Need:

• Excel Book
• Microsoft Excel

1. Open a spreadsheet file.
2. To freeze the top horizontal pane, select the row below where you want the split to appear.
3. To freeze the left vertical pane, select the column to the right of where you want the split to appear.
4. To freeze both the upper and left panes, click the cell below and to the right of where you want the split to appear.
5. Open the Window menu and select Freeze Panes. When you scroll through the worksheet, the area you selected remains on the screen.

Tips & Warnings

• Darker vertical and horizontal lines indicate which columns or rows are part of the freeze pane.
• Use Freeze Pane to help you when creating or editing large, unruly worksheets.
• The Freeze Pane rows and columns will not print as displayed in your worksheet.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.