How do I freeze specific rows in Excel?

How do I freeze specific rows in Excel?

Freeze columns and rows in Excel

  1. Select the row below the row(s) you want to freeze (select row 6, if you want to freeze rows 1 to 5).
  2. On the View tab, click Freeze Panes > Freeze Panes.

How do I freeze the first 3 rows in Excel 2010?

To freeze rows:

  1. Select the row below the rows you want frozen. For example, if you want rows 1 and 2 to always appear at the top of the worksheet even as you scroll, then select row 3.
  2. Click the View tab.
  3. Click the Freeze Panes command.
  4. Select Freeze Panes.
  5. A black line appears below the rows that are frozen in place.

How do I freeze multiple rows in Excel 2013?

To freeze rows:

  1. Select the row below the row(s) you want to freeze. In our example, we want to freeze rows 1 and 2, so we’ll select row 3.
  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 rows will be frozen in place, as indicated by the gray line.

How do I freeze multiple rows in Excel at the top?

How to Freeze Multiple Rows

  1. Select the row immediately below the rows you want to lock.
  2. Click on the “View” tab at the top and select the “Freeze Panes” command.
  3. From the resulting dropdown list, select the “Freeze Panes” command.

How do you freeze selected panes?

Select the View tab, Windows Group, click the Freeze Panes drop down and select Freeze Panes. Excel inserts a thin line to show you where the frozen pane begins.

How do I freeze multiple rows and columns 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 rows and columns at the same time in Excel 2016?

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 panes horizontally and vertically at the same time?

To freeze horizontal and vertical headings simultaneously:

  1. Select the cell in the upper-left corner of the range you want to remain scrollable.
  2. Select View tab, Windows Group, click Freeze Panes from the menu bar.
  3. Excel inserts two lines to indicate where the frozen panes begin.

How do you freeze multiple rows?