Demo: Freeze or unfreeze rows and columns

Worksheet with column selected Play Demo Demo button

(Or Download arrow download the demo.)

(You may experience a delay while the demo is loading.)

Navigating a large, complex worksheet with thousands of cells can be a challenge sometimes. The problem is that, as you scroll down, the column and row labels are no longer visible, so it's hard to tell what the data you're looking at refers to. By using the Freeze Panes command in Excel, you can make sure specific rows and columns stay visible while you scroll. Watch the demo to learn how to freeze and unfreeze rows and columns, and make viewing your worksheet a snap.

How to do it (text version):

Assistance Problems watching the video? Try our troubleshooting tips.

 
 
Applies to:
Excel 2007