Demo: Freeze or unfreeze rows and columns

Worksheet with column selected Play Demo Demo button

(Or Down 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):

Help Button Problems watching the video? Try our troubleshooting tips.

Applies To: Excel 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language