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

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on January 1, 2023

This tutorial demonstrates 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.

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

 

excel freeze panes ribbon

 

  1. Select Freeze Top Row.

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

 

excel freeze panes row68

 

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

 

excel freeze panes unfreeze

 

Freeze Panes

You can also freeze more than one row at a time.

  1. Position your cursor in the row you wish to freeze.
  2. In the Ribbon, select View > Freeze Panes > Freeze Panes.

 

excel freeze rows multiple rows

 

The worksheet freezes Rows 1 to 3. If you scroll down, these rows remain in view.

 

excel freeze panes multiple rows example

 

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

Freeze Top Row in Google Sheets

The process is similar in Google Sheets

  1. 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

 

  1. 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 you have selected.

 

excel freeze rows multiple google sheets

 

Note that the number in parentheses 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.

See also

AI Formula Generator

Try for Free

See all How-To Articles