Blog
>
Tutorials

How to Freeze a Header Row in Google Sheets (The Easy Way!)

In this article we will show you how to freeze the header row in Google Sheets so your header row will remain at the top of the spreadsheet as you scroll. This makes it substantially easier to understand data in a large spreadsheet.

2 Minutes

How to Create a Floating Header Row in Google Sheets

Creating a floating header is the same process as freezing a row, in these examples we will freeze the first row which is also the header row. We will first achieve this by using the menu method and then by using the drag method.

An example dataset has been created for this demonstration. You can follow along by clicking here to access our sample sheet:

Example 1 - Using the Freeze Menu

Step 1: Click any cell in the header row

In the dataset select a cell in the row you want to freeze. We want to freeze the header row we will select a cell in the header row.

Freeze header in Google Sheets

Step 2: Select View > Freeze > 1 row

From the View option in the top tool-bar select Freeze followed by 1 row. There are several other options in this menu but for this example we just wish to freeze the header row.

Freeze header in Google Sheets: Freeze Menu

Step 3: Scroll Down to See the Results

With the freeze applied scroll down. The header row remains locked in place.

Freeze header in Google Sheets: Freeze Applied

Example 2 - Use the Drag to Freeze Feature

Step 1: Hover Your Mouse Above the First Row Label

The grey line above the label of row 1 is the freeze line. See that the cursor turns to a hand icon when you hover over this.

Freeze header in Google Sheets

 

Step 2: Select and Drag the Freeze Line Past the Header Row

Click and drag the grey line underneath the label of the header row and release to apply the freeze.

Freeze header in Gogle Sheets: Freeze Applied

Step 3: Scroll Down to See the Results

Scroll down. The header row remains locked in place.

Freeze header in Google Sheets: Results

Lido is a new spreadsheet built for automation. Trigger emails, slack messages, and more directly from a spreadsheet.