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.

 

 

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.

 

 

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.

 

 

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

 

 

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.

 

 

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

 

 

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.

 

 

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

 

 

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

 

 

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.

 

 

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

 

 

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