How To Keep A Column From Moving In Excel?

How do I lock a column in Excel?

Do one of the following:

  • 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.

How do I freeze a column and a row in Excel?

Click on the cell just to the right of the column, and just below the row you want to freeze, and then select View → Window → Freeze Panes → Freeze Panes . So, if you want to freeze row 1 and the column A , click on B2 and select View → Window → Freeze Panes → Freeze Panes .

How do I freeze specific columns in Excel?

How to freeze multiple columns in Excel

  1. Select the column (or the first cell in the column) to the right of the last column you want to lock.
  2. Go to the View tab, and click Freeze Panes > Freeze Panes.