Video: Freeze or lock panes

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.

Other videos in this course

This video is part of a training course called Freeze or lock panes. You can download the entire course or watch the videos online:

  1. Video: Freeze or lock panes. (You are here!) 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.
  2. Video: Freeze panes in detail. 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.

Need a reminder of what you learned? See the course summary.

Ready for another tutorial? See the complete list of Excel 2013 training courses.

Rating:
Applies to:
Views:
47934
Submitted on:
6/22/2013
Length:
00:01:23