Related topics
×
Rows & columns
Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Rows & columns

Freeze columns or rows

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Try it!

Freeze rows and columns to keep specific areas visible when you scroll in a worksheet.

Freeze the first column

  • Select View > Freeze Panes > Freeze First Column.

    The faint line that appears between Column A and B shows that the first column is frozen.

Freeze the first two columns

  1. Select the third column.

  2. Select View > Freeze Panes > Freeze Panes.

Freeze columns and rows

  1. Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.

  2. Select View > Freeze Panes > Freeze Panes.

Want more?

Freeze rows and columns

Need more help?

Want more options?

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

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×