Add Headers or Footers in Google Sheets

A Google Sheets spreadsheet doesn’t secure a visual header or footer until you to favor to print. If you cherish to ought to add headers and footers to a Google Sheets spreadsheet, you’ll ought to exercise the printer settings menu—here’s how.

To open, open the Google Sheets spreadsheet that contains your data. At the pause, click File > Print to peek the printer settings menu to your document.

An inventory of accessible suggestions for each and each headers and footers will appear. Click on the checkbox subsequent to a preset probability (to illustrate, “Page Numbers”) to enable it.

You are going to be in a situation to add web page numbers, a workbook title, sheet name, or the fresh date or time to your printed spreadsheet. Google mechanically determines whether or no longer to position these within the header or footer.

As an illustration, web page numbers are mechanically positioned within the footer, while a workbook title will be positioned within the header. If you cherish to ought to alternate the effect of a preset probability or add any customized textual convey to a header or footer, click “Edit Custom Fields.”

The print peek on the proper will alternate and wait on you edit the textual convey containers within the header or footer. Click on a field to create any changes to your header or footer.

Would possibly per chance secure to you’re ready to put your changes, click “Verify” on the pause proper to approach again to the “Print Settings” menu.

If you’re pleased with the changes you made to your header or footer, click “Subsequent” on the pause proper.

You’ll now be taken to your browser or operating machine’s printer suggestions menu. Here, you might presumably specify more print settings to your spreadsheet, cherish the form of copies you cherish to ought to print.

The changes you made to your header or footer will put mechanically, and they’ll furthermore be applied to any future copies of your Google Sheets spreadsheet that you print.