Freeze the Top Row

Keep your headers visible while you scroll through long data.

You will learn to

  • Freeze the header row

How it works

In Excel choose View → Freeze Panes → Freeze Top Row. The header row stays visible as you scroll. Use Freeze First Column to lock the left column, or Freeze Panes to lock both above and left of the selected cell.