How to Add Repeat Page Titles in Google Sheets

Published on

This tutorial explains how to repeat page titles at the top or left of pages in printouts using frozen rows and columns in Google Sheets.

Repeating page titles on every page is important when printing your data because it makes your printout reader-friendly.

To repeat page titles, add the header row (the top row with labels) to the top of every printed page or add the first column (the left column with labels) to the left of every printed page.

If you do not use the print title feature in Google Sheets, you can manually copy and paste the title row to the top of each page or the first column to the left of each page. However, this will destroy your data structure and affect filtering and formulas in the sheet.

Therefore, it is best to use the print title feature whenever you need to print multiple pages of spreadsheet data in Google Sheets.

How to Print Page Titles on Every Page in Google Sheets

Google Sheets does not allow you to select a row or column from the middle of a table and repeat it as the page title on every page. Instead, Google Sheets can only print titles up to the header row or column, because it uses the Freeze rows and columns feature for this.

The Freeze feature allows you to lock your rows, columns, or both in a Sheet. Let’s see how it affects printing in Google Sheets.

Repeat Page Titles at the Top of Printed Pages

Adding Repeat Page Titles in Google Sheets

To repeat page titles on the top of every printed page in Google Sheets, follow these steps:

Remove any frozen rows and columns. To do this, click View > Freeze > No rows and then View > Freeze > No columns.

Go to the row that you want to repeat at the top of every printed page. In our example, this is row 4.

Click View > Freeze > Up to row 4. This will place a shaded bar at the bottom of row 4 across the row. Hereafter, when you scroll the page down, the top four rows will be frozen.

How to Freeze Rows in Google Sheets

Click File > Print. This will open the print dialog box (a sidebar panel) on the right-hand side of the screen.

Scroll down to the bottom of the print dialog box and make sure that “Repeat frozen rows” under the “Row & Column headers” is checked. If not, check it.

How to Repeat Frozen Rows in Google Sheets

Click Next (a blue button at the top) > Print.

When you print your Google Sheets data, you will see the page titles repeated on each and every page.

Repeat Page Titles at the Left of Printed Pages

In the above example, we have vertically arranged data, so we have a header row to repeat on every printed page. But what about horizontally arranged data?

Assume we have transposed the above same sample data. Then we have columns to repeat on every page, not rows.

Horizontal Data and Adding Page Titles

To repeat page titles in columns on every page, follow these steps:

  1. Remove any frozen rows and columns (View > Freeze > No rows/No columns).
  2. Go to the column that you want to repeat at the top of every printed page. In our example, this is column B.
  3. Click View > Freeze > Up to column B. This will place a shaded bar at the right-hand side of column B down the column. Hereafter, when you scroll the page to the right-hand side, the left two columns will be frozen.
  4. Click File > Print.
  5. On the print dialog box, make sure that “Repeat frozen columns” is checked. If not, check it.
  6. See the preview.
Repeat Columns at the Left of the Printed Pages

Conclusion

Do you see any drawbacks to the current repeat rows settings using frozen rows and columns in Google Sheets?

Yes, there is one drawback. When you repeat print titles on the top of a spreadsheet, any values in the frozen rows will be repeated on the top of every page. This can be a problem if you have important data in the frozen rows that you don’t want to be repeated.

For example, if you have frozen the top 4 rows of a spreadsheet, but the header row is in row 4, then any values in rows 1 to 3 will be repeated on the top of every page.

Keep this in mind when using the repeat rows or columns settings in Google Sheets when printing.

Prashanth KV
Prashanth KV
Your Trusted Google Sheets and Excel Guide Prashanth KV brings a wealth of experience in Google Sheets and Excel, cultivated through years of work with multinational corporations in Mumbai and Dubai. As a recognized Google Product Expert in Docs Editors, Prashanth shares his expertise through insightful blogging since 2012. Explore his blog for practical tips and guidance on maximizing your spreadsheet skills.

Lookup Values Under Categories in Excel and Google Sheets

We can use a combination of XLOOKUP and VLOOKUP in both Excel and Google...

Extract Items Under a Category from the Same Column in Excel

In Excel, you can use a combination of the XLOOKUP and DROP functions to...

How to Create a Searchable Table in Excel Using the FILTER Function

Finding specific records, or rows containing the required information, is straightforward in Excel using...

Time Sequences in Excel by Minute, Hour, or Second Increments

Creating time sequences, whether by hour, minute, or second increments in Excel, can be...

More like this

XMATCH Row by Row: Finding Values Across a Range in Google Sheets

Using the BYROW function with XMATCH in Google Sheets allows us to match values...

Limit Formula Expansion to a Specific Row in Google Sheets

In this tutorial, I’ll explain how to limit the expansion of an array formula...

3-D Referencing Structured Data Tables in Google Sheets

When you have several tables within a single sheet—not across multiple sheets in a...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.