How do I freeze the top row and panes in Excel?

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 get rid of header freeze in Excel?

You’re scrolling down your worksheet (or scrolling to the side), but part of it is frozen in place. This is probably because at some point you decided to freeze the panes. To fix this, click View > Window > Unfreeze Panes.

How do you freeze selected rows in Excel?

Freezing a Row Select the row below the row you want to freeze. To select a row, you need to select the entire row on the left side. With the row selected, click on the “View” tab at the top, select “Freeze Panes” and you’ll see several different options you can choose: “Freeze Panes” will freeze all rows above your selected row.

How do you turn rows into a header in Excel?

Click the button next to “Rows to repeat at top.”. This will allow you to select the row(s) that you want to treat as the constant header. Select the row(s) that you want to turn into a header. The rows that you select will appear at the top of every printed page.

Where is the Freeze button in Excel?

Freeze pane function is found in the VIEW tab > Window group > freeze tab. As you click on the drop down menu you will find three options to freeze pane. Select the option and your row or column will freeze.

How do you freeze multiple areas in Excel?

Freeze Panes in Excel: Instructions. To freeze panes in both columns and rows in a worksheet, select the cell below the row and to the right of the column to freeze. Click the “View” tab in the Ribbon. Then click the “Freeze Panes” button in the “Window” button group. Then choose the “Freeze Panes” command from the drop-down menu.