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.

See Also

Freeze rows and columns

Freeze panes to lock the first row or column

Video: Freeze panes in detail

Video: Freeze or lock panes

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!