See all How-To Articles

Define Print Titles (Rows) on Every Page in Excel & Google Sheets

In this tutorial, you will learn how to define print titles – rows and/or columns printed on every page – in Excel and Google Sheets.

 

print preview page 2a

 

In Excel, you can use Page Setup to print the top row or the leftmost column on every page. We’ll explain in detail how to set the top row to repeat, and the procedure is the same for setting the column. You can set as many rows or columns as you need.

Define Print Titles

There is often a need to print a title row on every page. For example, when you have data table printed on multiple pages, you’ll usually need to print a table heading row on each page. Let’s say that we have the following sales data table.

 

define print titles initial data 1

 

This table has 100 rows of data, so it will need multiple pages for printing. Let’s say we want to repeat Row 1 (the table headings, sometimes called “field names”) at the top of every page. To achieve this, follow these steps:

1. In the Ribbon, (1) go to the Page Layout tab, and in the Page Setup group, (2) click on Print Titles.

 

print titles page setup 1

 

2. In the Page Setup window, click on the arrow next to the Print area box.

 

set print area 1

 

3. Now (1) select the print area (in this case, Columns B:G) and (2) press ENTER or click on the arrow on the right side of the box.

 

set print area 2a

 

4. Next, set which rows you want to repeat at the top. Click on the arrow next to the Rows to repeat at top box.

 

rows to repeat 1

 

5. Select Row 1 to repeat this row on each page, and (2) press enter or click on the arrow on the right side of the box.

 

rows to repeat 2a

 

6. Now you can see how the pages will look when they’re printed. In the Page Setup window, click on Print Preview.

 

print preview excel 1

 

When the Print Preview screen appears, you can see that the first row is printed at the top of the first page. If you switch to Page 2, there is also the first row at the top of it and this will be the case on every page in the document.

 

print preview page 2a

 

Just like repeating rows at the top, you can also repeat columns on the left side of every page. The only difference is that, in the Page Setup window, you need to select one or more columns in the Columns to repeat at left box.

 

columns to repeat at left 1

 

Define Print Titles in Google Sheets

Repeating rows or columns when printing works differently in Google Sheets. Here, you can repeat only rows and columns that are frozen in the worksheet. Therefore, we’ll first show how to freeze top rows or left columns and then how to print them.

Freeze Top Rows

If you want to freeze one or more rows at the top of the worksheet in Google Sheets, you need to follow these steps:

1. First, (1) select the row(s) that you want to freeze. In this case, select Row 1, as you want only the heading row to be frozen. Next, (2) go to the View tab in the Menu, (3) click on Freeze, and (4) choose Up to current row (1).

Note that you could also just select 1 row in this case, since you want to freeze just the first row, but if you want to freeze multiple rows, you’ll need to select Up to current row.

 

google sheets freeze top rows 1

 

As a result, the first row is fixed when you scroll down the worksheet.

 

google sheets freeze top rows 2a

 

Repeat Frozen Rows When Printing

Now you can see the Print Preview of the worksheet and set the rows to repeat on each page.

1. In the Menu, go to File > Print (or use the keyboard shortcut CTRL+P).

 

google sheets print 1

 

2. Now in the print options on the left side, (1) expand the headers and footers section, and (2) check Repeat frozen rows.

 

google sheets repeat frozen rows 1

 

As you can see in the Print Preview, the first row will print on both pages.

In a similar way, you can also freeze column(s) on the left side and repeat them on every page when printing. You just need to check Repeat frozen columns in the print settings.