Easy Tech TutsHow to Add Header and Footer in Google Sheets Easily 2026
By Impran M N
Preparing a spreadsheet for printing or PDF export often means adding headers and footers with page numbers, titles, or dates so the document looks organized. Google Sheets has a dedicated print layout panel for this, and this guide walks through enabling and customizing those fields.
01Open the print settings menu
Go to File and open the print settings panel for your spreadsheet.
02Find the Headers and Footers section
Locate the sidebar section dedicated to headers and footers within the print layout.
03Enable default attributes
Turn on checkboxes for default fields like sheet name and current date.
04Open Edit Custom Fields
Use the custom fields wizard to type in personalized text entries for your header or footer.
05Position your text and page numbers
Place page numbers, titles, and timestamps in the left, center, or right boxes as needed.
06Confirm and preview
Save your changes and preview the final layout to confirm it looks right before exporting or printing.
Frequently asked questions
Can I add page numbers automatically?
Yes, default attribute checkboxes let you enable page numbers along with other fields like the current date.
Can I repeat frozen rows across multiple printed pages?
Yes, the print layout panel includes an option to repeat frozen row titles automatically on every printed page.
Where do custom header text entries go?
The Edit Custom Fields wizard lets you type personalized text and position it in the left, center, or right sections of the header or footer.
Do header and footer settings affect the on-screen spreadsheet view?
No, these settings only apply to the printed or exported PDF version, not your regular editing view.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
