Quick Links

Key Takeaways

  • To add headers or footers to a Google Sheets spreadsheet, go to the printer settings menu by clicking File > Print or pressing Ctrl+P.
  • Customize your layout and design in the "Headers and Footers" section. You can enable preset options like page numbers, the name of the sheet, and more.
  • Add custom text by clicking "Edit Custom Fields. "Make changes to the text boxes in the header or footer, then click "Confirm" to save.

A Google Sheets spreadsheet doesn't have a visible header or footer until you decide to print. If you want to add headers and footers to a Google Sheets spreadsheet, you'll have to use the printer settings menu—here's how.

To begin, open the Google Sheets spreadsheet that contains your data. At the top, click File > Print to view the printer settings menu for your document. You can also press Ctrl+P if you like to use hotkeys.

Open File, then click "Print."

In the "Print Settings" menu, you can customize the layout and design of your spreadsheet to make it suitable for printing. To add a new header or footer, click the "Headers and Footers" category in the menu on the right.

Headers and Footers section in Google Sheets.

A list of available options for both headers and footers will appear. Click the checkbox next to a preset option (for example, "Page Numbers") to enable it.

Options available to place in the Header or Footer.

You can add page numbers, a workbook title, sheet name, or the current date or time to your printed spreadsheet. Google automatically determines whether to place these in the header or footer.

For example, page numbers are automatically placed in the footer, while a workbook title will be placed in the header. If you want to change the position of a preset option or add any custom text to a header or footer, click "Edit Custom Fields."

Select "Edit Custom Fields" under the preexisting Header and Footer options.

The print view on the right will change and allow you to edit the text boxes in the header or footer. Click a box to make any changes to your header or footer.

The fields you can edit manually highlighted in red.

When you're ready to save your changes, click "Confirm" at the top right to return to the "Print Settings" menu.

Click the "Confirm" button. It'll appear blue if you make a valid change.

If you're happy with the changes you made to your header or footer, click "Next" at the top right.

Click the "Next" button in the top right corner.

You'll now be taken to your browser or operating system's printer options menu. Here, you can specify more print settings for your spreadsheet, like the number of copies you want to print.

The changes you made to your header or footer will save automatically, and they'll also be applied to any future copies of your Google Sheets spreadsheet that you print.