In this article:

How to Repeat Header Rows in Google Sheets (2024 Update)

May 8, 2024

How to Repeat Header Rows in Google Sheets

Follow the steps below to easily repeat header rows in Google Sheets. 

1. Highlight the Header Row(s) You Want to Repeat

Begin by clicking on the row number of your header row to highlight it. If your header covers more than one row, click and drag across the row numbers to select all relevant rows.

google sheets repeat header row

2. Access "View" Menu in Google Sheets

Navigate to the top menu in Google Sheets and click on "View". This will display a dropdown menu with various options.

how to repeat header rows in google sheets

3. Hover Over "Freeze" Option in the View Menu

In the dropdown menu, move your cursor over "Freeze". A side menu will appear, presenting options to freeze either rows or columns.

repeat header row in google sheets

4. Select the Number of Rows to Freeze Based on Your Header

From the side menu, select the number of rows you wish to freeze based on your header's size. For instance, if your header is one row, choose "1 row". For a two-row header, select "2 rows".

how do you repeat a header row in google sheets

5. Scroll to Confirm Header Rows Are Frozen

To ensure your header rows are frozen, scroll down through your sheet. The header rows should remain visible at the top as you scroll, indicating they are correctly frozen.

6. Print or Export Your Sheet with Repeated Headers (Optional)

If you need to print your sheet or save it as a PDF, go to "File" > "Print".

This allows you to preview how your document will look with the repeated header rows. Adjust any print settings as required before printing or saving.

We hope that you now have a better understanding of how to repeat header rows in Google Sheets. If you enjoyed this article, you might also like our article on how to set up Google Sheets Monte Carlo simulation or our article on how to import weather data into 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.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

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