See all How-To Articles

Lock the Top Row / Header When Scrolling in Excel & Google Sheets

This tutorial will demonstrate how to make the top row stay visible in Excel and Google Sheets.

 

excel freeze panes example

 

Freeze Top Row

In a large worksheet with headings, you might want to make sure that the top row repeats when scrolling, so you can always see it.

In the Ribbon, select View > Freeze Panes.

 

excel freeze panes ribbon

 

Select Freeze Top Row.

As you scroll down in your worksheet, you will see that the top row remains visible regardless of how far you scroll down.

 

excel freeze panes row68

 

To remove the pane freeze, select Unfreeze Panes from the Freeze Panes menu.

 

excel freeze panes unfreeze

 

Freeze Panes

You might want to freeze more than one row. To do this, you can use Freeze Panes.

Position your cursor in the row you wish to freeze.

In the Ribbon, select View > Freeze Panes > Freeze Panes.

 

excel freeze rows multiple rows

 

The worksheet will freeze rows 1 to 3. If you scroll down, these rows will remain in place.

 

excel freeze panes multiple rows example

 

To remove the pane freeze, select Unfreeze Panes from the Freeze Panes menu.

Freeze Top Row in Google Sheets

In the Menu, click View > Freeze > 1 row.

 

excel freeze panes google sheets menu

 

As you scroll down, the top row remains in place.

 

excel freeze panes google sheets example

 

Click View > Freeze > No rows to remove the freeze.

 

excel freeze panes google sheets unfreeze

 

To freeze more than one row in Google Sheets, you can select either 2 rows to freeze the top two rows, or Up to current row (row) to freeze up to the row that you have selected.

 

excel freeze rows multiple google sheets

 

Note that the number in brackets after Up to current row reflects the current row selected.

 

excel freeze panes multiple row google sheets

 

You can also use the Freeze Panes menus to freeze columns.