Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web
  1. To freeze two or more rows, select the row below the ones to be frozen.

  2. On the View tab, select  Freeze panes button Freeze Panes and then choose  Freeze panes button Freeze Panes.

For more info, see Freeze panes to lock rows and columns.

Tip: To freeze just the top row, go to View, select Freeze Panes, and then  Freeze top row button Freeze Top Row.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.