How to freeze a row and column or both in Microsoft Excel

  • Published date: December 4, 2017
    • Pakistan

Freeze a row and column or both in Microsoft Excel



Freeze Pane in Microsoft Excel


To lock one row only, choose the View tab, and then click Freeze Top Row.


To lock one column only, choose the View tab, and then click Freeze First Column.


To lock more than one row or column, or to lock both rows and columns at the same time, choose the View tab, and then click Freeze Panes. You will want your cursor to be below the row(s) you want to freeze and to the right of any column(s) you want to freeze.


To lock multiple rows select the row below the last row you want frozen, choose the View tab, and then click Freeze Panes.


To lock multiple columns, select the column to the right of the last column you want frozen, choose the View tab, and then click Freeze Panes.

Share by email Share on Facebook Share on Twitter Share on Google+ Share on LinkedIn Pin on Pinterest

Useful information

  • Avoid scams by acting locally or paying with PayPal
  • Never pay with Western Union, Moneygram or other anonymous payment services
  • Don't buy or sell outside of your country. Don't accept cashier cheques from outside your country
  • This site is never involved in any transaction, and does not handle payments, shipping, guarantee transactions, provide escrow services, or offer "buyer protection" or "seller certification"

Leave your comment (spam and offensive messages will be removed)

Related listings