In this article:

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

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 nd how to freeze multiple rows in Google Sheets. We also recommend reading our guide on how to mail merge in Google Sheets.

Check out our workflow approval software.

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started