How do I freeze multiple columns and rows in Excel 2013?

How do I freeze multiple columns and rows in Excel 2013?

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.

How do I freeze multiple panes in Excel 2013?

How to Freeze Multiple Rows in Excel 2013

  1. Open your Excel file.
  2. Click the row number below the bottom row to freeze.
  3. Click View.
  4. Choose Freeze Panes, then select Freeze Panes from the dropdown.

How do I freeze just a column in Excel?

Freeze rows or columns

  1. To lock one row only, choose the View tab, and then click Freeze Top Row.
  2. To lock one column only, choose the View tab, and then click Freeze First Column.
  3. 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 vertical and horizontal panes in Excel 2013?

To freeze horizontal and vertical headings simultaneously: Select the cell in the upper-left corner of the range you want to remain scrollable. Select View tab, Windows Group, click Freeze Panes from the menu bar.

How do I protect certain columns in Excel?

Go to the Protection tab and uncheck Locked option and click Ok. Now select only the cells or columns, rows that you want to protect. Right click and choose Format cells again. Go to the protection tab and check Locked option and click Ok.

How do I lock two 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.

How do I freeze a column?

To freeze columns:

  1. Select the column to the right of the column(s) you want to freeze.
  2. Click the View tab on the Ribbon.
  3. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.
  4. The column will be frozen in place, as indicated by the gray line.

How do I freeze both horizontal and vertical panes?

To freeze horizontal and vertical headings simultaneously: Select View tab, Windows Group, click Freeze Panes from the menu bar. Excel inserts two lines to indicate where the frozen panes begin.