Freeze or lock panes

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

You want to scroll down and see your rows of data, but when you get to the bottom of the screen, your column names in the top row have disappeared. To fix this, you freeze the top row so that it's always visible. Good news – the command is easy to get to. Click View > Freeze Panes > Freeze Top Row.

Inside this course:

Freeze or lock panes (1:23)
You want the header row to remain visible when you scroll, to show what’s in each column. To do this, click Click View > Freeze Panes > Freeze Top Row. If, instead, you want column A to always remain visible, click View > Freeze Panes > Freeze First Column. To unfreeze the panes, click Freeze Panes > Unfreeze Panes.

Freeze panes in detail (4:00)
In this video, we’ll cover freeze panes in detail, including freezing the top row and left column at the same time, multiple rows and columns, and printing the header on every page.

Course summary
A brief reminder of the key points in this course.

More courses available at Microsoft Office Training.

Applies To: Excel 2013

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