How do I freeze only certain rows in Excel?

Do one of the following:

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 only certain 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 the first 3 columns in Excel?

How to freeze multiple columns in Excel

1. Select the column to the right of the last column you want to freeze. For example, if you want to freeze the first 3 columns (A – C), select the entire column D or cell D1.
2. And now, follow the already familiar path, i.e View tab > Freeze panes > and again Freeze panes.

How do I freeze a selected row?

To freeze several rows:

1. Select the row that is immediately beneath the last row you want frozen.
2. From the View tab, Windows Group, click the Freeze Panes drop down and select Freeze Panes.
3. Excel inserts a thin line to show you where the frozen pane begins.

Why is Excel not freezing the panes that I select?

Unfreeze Worksheet Pane: For this, you should click to the View tab and then from the Window group, you should select the Freeze Panes arrow sign. Now from the drop-down menu, you should select the “Unfreeze Panes”. This method helps in fixing the issue.

How do I freeze specific rows?

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 only certain rows?

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 non consecutive rows in Excel?

Select the row below the row(s) you wish to freeze. Click the View tab on the Ribbon. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. … Your selection will be frozen in place.

How do I freeze multiple rows in Excel 365?

Freeze columns and rows to keep them in view while you scroll through your data.

1. Select the cell below the rows, and to the right of the columns you want to freeze.
2. Click View > Freeze Panes > Freeze Panes.

To freeze certain rows in Excel, first scroll to the first row to be frozen (the first row you want to freeze needs to be the first row visible on screen), now select all the rows you want to freeze and click the Freeze Panes button. Do the same if you wish to freeze certain columns.

How to freeze top three rows in Excel?

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. See More…

How do you freeze selection of cells in Excel?

Locking a row below the first row follows similar steps. First, select the cell in column A below the last row to freeze. Click the “View” tab, click “Freeze Panes,” then click “Freeze Panes” from the drop-down menu. All rows above the selected cell will now freeze.

Can’t freeze multiple rows in Excel?

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