In this article:

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

May 8, 2024

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

We hope this article has helped you and given you a better understanding of how to freeze a header row in Google Sheets. You might also like our articles on how to make a row sticky in Google Sheets and how to freeze multiple rows in Google Sheets. We also recommend reading our guide on how to mail merge in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->