Freezing a header keeps it visible while scrolling, but repeated print headers need a separate print setting. Check both controls before duplicating header rows manually.
Freeze the intended header
On a computer, select the relevant row area and use View > Freeze to choose the number of frozen rows. Include only the rows needed to identify the columns or report context.
Scroll the sheet to confirm the correct boundary. A large frozen block can consume unnecessary screen and print space if it includes notes or unused rows.
Enable repetition for the print job
Open File > Print, expand Headers & footers, and choose Repeat frozen rows. Google also provides Repeat frozen columns for suitable horizontally paginated reports.
This is different from adding page numbers, a file title, or a custom page header. Inspect each option’s actual effect rather than assuming any header setting repeats the spreadsheet’s column labels.
Verify later pages
Review at least the second page and the last page. Check that repeated rows are readable and do not crowd out the data. Confirm totals and section labels still make sense across page boundaries.
Do not insert duplicate header records into the dataset merely to improve printing; those rows can interfere with sorting, formulas, and pivot tables. Keep repeated presentation in the print configuration. Verify the exported PDF or physical print sample at normal size, and record the selected range and orientation when the output must be reproduced later. A correct first page alone does not test whether the header repeats throughout the complete report.
References
Reviewed against the linked official product guidance on November 3, 2026. Features, limits, screen labels, and access can vary by account, platform, region, and organization policy.