Excel 2013

  1. Select the row below the row(s) you want to freeze (select row 6, if you want to freeze rows 1 to 5).

  2. On the View tab, click Freeze Panes > Freeze Panes.

Excel 2016

  1. Select the row below the row(s) you want to freeze (select row 6, if you want to freeze rows 1 to 5).  

  2. On the View tab, click Freeze Panes > Freeze Panes.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×