Knowing how to repeat page titles in Google Sheets is useful when you need to print a spreadsheet with large amounts of data that can span multiple printed pages (two or more).
Table of Contents
In this article, you’ll learn how to freeze rows (or columns) so that you can repeat page titles when printing your spreadsheet. This is a quite simple yet very useful option you can easily learn how to use.
Let’s take a look at one example, first!
Say you have a list of clothing inventory. Dozens of rows with clothing items, and several columns representing their type, color, size, quantity, price, and more. When you go to File > Print, to print your spreadsheet, you’ll see it spans multiple printed pages. You may still be able to read and understand your data but someone else probably won’t. This is why you need to repeat page titles in Google Sheets.
But how do we do that?
Easy. No, you don’t need to copy/paste the titles, there’s a better way to do it. You should freeze the rows that contain page titles you’d want to print and adjust some print settings to make the printout neat and readable.
Let’s try together, step-by-step!
How to Repeat Page Titles in Google Sheets
As mentioned earlier, to repeat page titles in Google Sheets, you should first know how to freeze rows. Let’s go back to our clothing inventory so that you can see a real example of how this works.
- First, open the sheet you’d want to print, and count the rows with the titles you’d want to repeat. You can either select those rows or click on any cell in the last row that contains the title. In our example, we’d want to repeat page titles from the first two rows.
- Then, go to the main menu and choose View > Freeze rows > Up to current row (2). This will freeze the first two rows of the sheet. Scroll down to see how it looks (other rows will move but those two will stay in place).
- Select the data range you’d want to print. In our example, this would be the range A1:H41
- Now, go back to the menu but this time choose File > Print to open the ‘Print settings’. You can also access these settings by pressing Ctrl+P on your keyboard.
- Once the ‘Print settings’ open, you can start adjusting them. First, change what you’d want to print. Instead of the whole ‘Current sheet’, we’d want to print only the ‘Selected cells (A1:H41)’.
- Then, you can change other features, such as paper size, page orientation, scale, margins, and more. Play with them, until your pages are good enough for printing.
Look at the preview of printed pages and you’ll see that frozen rows repeat on each and every one of them.
That’s all! Now you know how to freeze rows and repeat page titles in Google Sheets. It wasn’t that hard, wasn’t it?
Use the link below to make a copy of our example spreadsheet and see what you’ve learned so far:
But first, you’ll need to unfreeze the rows we’ve just frozen. Do you know how to do it?
Just go to the main menu and choose View > Freeze rows > No rows. This will unfreeze all of the rows that were frozen. Similarly, if you need to unfreeze columns, select ‘No columns’ instead of ‘No rows’.
⚠️ A Few Notes About Freezing Rows or Columns in Google Sheets:
- The same way you freeze rows, you can freeze columns, as well, just select ‘Up to current column’ instead of ‘Up to current row’.
- You can’t freeze rows or columns that contain only part of a merged cell. If this happens, you should either freeze more rows or columns to include the complete merged cells or break apart merged cells.
- There’s another way to freeze rows or columns that will especially come in handy if you need to make adjustments to the rows or columns that are already frozen and want to speed up the process. Just hover your mouse over the frozen bar and your cursor will turn into a hand. Use left click on your mouse to pick up the bar, and drag it to its new place in the sheet. Release the bar. If no rows or columns are frozen, you’ll find these bars in the upper left corner of your spreadsheet.
That’s all. Do this every time you want to print data that spans multiple printed pages and you’ll see how page titles repeat on each and every printed page.
And if you need help making your sheet easier to understand, check out our other Google Sheets formulas you can use to make your sheet neat and easy to read 🙂