Better Sheets

How to freeze multiple rows in Google Sheets

Open View → Freeze → 1 row (or 2 rows / Up to row …) to lock header rows while you scroll. You can also drag the horizontal freeze handle under the row numbers. Use this so labels stay on screen as you move through long lists.

Steps

1
Put headers in the top row(s).
2
Go to View → Freeze.
3
Choose 1 row, 2 rows, or Up to current row.
4
Clear later with View → Freeze → No rows.

Related tutorials

These videos might help you go deeper on this topic.

Browse more tutorials

How to Insert Multiple Rows in Google Sheets (Easy to Hard)

Learn how to add multiple rows to your google sheets by hand, and automa...

Advanced Intermediate Beginner

Create an Internal Google Sheets Add-on

The entire process to create and publish a Google Sheets Add-on internal...

Intermediate

Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script

This is one of the most popular asked first "automations". How to move a...

Unlock these tutorials

Related blog posts

Written guides that go deeper on this question.

Browse the blog

Automate Row Deletion in Google Sheets with Apps Script

In this post, we'll cover how to remove rows automatically in Google Sheets using Apps Script, ensuring you save time and streamline your spreadsheet management. You're probably already familiar with the manual way of right-clicking and deleting rows, but there's a more efficient way to handle this—automation! Manual versus Semi-Automatic Deletion You may know that you can manually delete rows in Google Sheets by right-clicking and selecting "Delete row." You can even select multiple rows...

Better Sheets on YouTube

Watch matching videos from youtube.com/bettersheets.

No exact channel match cached for “How to freeze multiple rows in Google Sheets” yet. Search Better Sheets on YouTube.

Terms and formulas behind this

Want the full definition or how a formula works? Start here.

Freeze rows and columns

Freezing locks the top rows or left columns in place while the rest of the sheet scrolls. View > Freeze lets you pin ...

ROWS()

Google Sheets ROWS() function guide

ROW()

Google Sheets ROW() function guide

Related questions

How to freeze rows on Google Sheets

Open View → Freeze → 1 row (or 2 rows / Up to row …) to lock header rows while you scroll. You can also drag the horizontal freeze handle under the row numbers. Use this so labels stay on screen as you move through long lists.

Get the answer →

How to freeze rows Google Sheets

Open View → Freeze → 1 row (or 2 rows / Up to row …) to lock header rows while you scroll. You can also drag the horizontal freeze handle under the row numbers. Use this so labels stay on screen as you move through long lists.

Get the answer →

How to freeze 3 rows in Google Sheets

Open View → Freeze → 1 row (or 2 rows / Up to row …) to lock header rows while you scroll. You can also drag the horizontal freeze handle under the row numbers. Use this so labels stay on screen as you move through long lists.

Get the answer →

How to freeze row on Google Sheets

Open View → Freeze → 1 row (or 2 rows / Up to row …) to lock header rows while you scroll. You can also drag the horizontal freeze handle under the row numbers. Use this so labels stay on screen as you move through long lists.

Get the answer →

How to freeze a row on Google Sheets

Open View → Freeze → 1 row (or 2 rows / Up to row …) to lock header rows while you scroll. You can also drag the horizontal freeze handle under the row numbers. Use this so labels stay on screen as you move through long lists.

Get the answer →

Where is merge and center in Google Sheets

Select the cells, then Format → Merge cells (or the toolbar Merge icon). Choose Merge all, horizontally, or vertically. Only the top-left value is kept. Avoid merging inside data tables you still sort or filter.

Get the answer →

Need more than a quick answer?

Membership unlocks 636+ tutorials, unlimited generators, and every template.

Unlock the tutorial library Browse free answers