In Excel, go to Page Layout, choose Print Titles, click in Rows to repeat at top and select the header row. Every printed page of a long transaction list then starts with the same heading row. In Google Sheets, freeze the row first and tick the option to repeat frozen rows in the print settings.
How do you repeat the header row in Excel?
- Open the sheet with the long list, such as a year of transactions.
- Click the Page Layout tab and then Print Titles in the Page Setup group.
- In the dialog, click the box beside Rows to repeat at top.
- Click the header row on the sheet. The box shows something like $1:$1.
- Press OK, then check with File, Print.
If your heading takes two rows, say a title on row 1 and column names on row 2, select both so the box reads $1:$2. You can also type the reference straight into the box.
Why is Print Titles greyed out?
- You are editing a cell. Press Esc or Enter first.
- A chart or shape is selected. Click a plain cell.
- Several sheets are grouped. Right-click a tab and choose Ungroup Sheets.
How do you check it worked?
Press Ctrl and P to open the print view. Go to page 2 in the preview at the right. The header should appear above the first row on that page. If it only shows on page 1, the setting was not saved for this sheet; each sheet has its own Print Titles.
How do you repeat the header row in Google Sheets?
Sheets uses the frozen row as the repeating one:
- Click a cell in the header row, then go to View, Freeze, and choose 1 row (or up to current row if your header spans two).
- Press Ctrl and P to open the print settings.
- Open the Headers and footers section on the right.
- Tick Repeat frozen rows.
- Check the preview, then continue to print or save as PDF.
What other print settings go with it?
| Setting | Where in Excel | Why |
|---|---|---|
| Landscape | Page Layout, Orientation | A wide statement with many columns fits better |
| Fit all columns on one page | Page Layout, Width set to 1 page, Height set to Automatic | Stops one column spilling onto its own page |
| Page numbers | Page Layout, Page Setup, Header and Footer | Shows Page 2 of 6 so loose sheets stay in order |
| Print area | Page Layout, Print Area, Set Print Area | Leaves out notes or scratch columns |
What if the list is very long?
A year of transactions can run to many pages. Before you print, check whether you really need paper. A PDF is easier to share and to search. If you must print, filter the list to one account or one month first, so the paper holds only what the reader needs.
A quick final check
- The header row text is bold and shaded so it stands out.
- Column widths show full dates and amounts, with no hash signs.
- The last page is not nearly empty because of one stray row.
Does Print Titles also repeat columns?
Yes. In the same Print Titles dialog, the second box, Columns to repeat at left, keeps the first column on every page when a wide sheet spills across several pages. This helps with a monthly grid where the first column holds names or bed numbers. Select that column in the same way, so the box reads $A:$A, and check in Print Preview on a page to the right of the first.
When a sheet becomes a long list of transactions, SpendixAI offers reports and a CSV download, so you can export a smaller, filtered slice and print only that.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


