Google Sheets

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

To brainstorm, open the Google Sheets spreadsheet that contains your data. At the height, click File > Print to view the printer settings menu for your certificate.

On your Google Sheets spreadsheet, press File > Print to access the printer options for your spreadsheet.

In the "Impress Settings" menu, you lot can customize the layout and pattern of your spreadsheet to brand information technology suitable for printing. To add a new header or footer, click the "Headers and Footers" category in the menu on the right.

To add a custom header or footer, press the "Headers and Footers" category to view a list of available options in the "Print Settings" menu.

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

Click one of the available preset options in the "Headers and Footers" category in the "Print Settings" menu to add those features to your printed spreadsheet.

Yous can add together page numbers, a workbook championship, sheet proper noun, or the current date or time to your printed spreadsheet. Google automatically determines whether to place these in the header or footer.

For example, folio numbers are automatically placed in the footer, while a workbook title will be placed in the header. If y'all desire to change the position of a preset option or add together any custom text to a header or footer, click "Edit Custom Fields."

Click "Edit Custom Fields" in the "Headers and Footers" category in the "Print Settings" menu to customize the header and footer of a printed Google Sheets spreadsheet.

The print view on the correct will modify and let you to edit the text boxes in the header or footer. Click a box to brand any changes to your header or footer.

Click on an available text box in the header or footer areas of the visible Google Sheets print view to add, remove, or change the existing header or footer text.

When you're gear up to salvage your changes, click "Ostend" at the top right to return to the "Print Settings" menu.

Press "Confirm" in the top-right corner to save the changes to your custom Google Sheets header or footer.

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

After customizing your header or footer, press "Next" in the top-right corner of the "Print Settings" menu to begin printing your edited Google Sheets spreadsheet.

You'll now exist taken to your browser or operating system'south printer options bill of fare. Hither, you lot can specify more print settings for your spreadsheet, like the number of copies yous want to print.

The changes you fabricated to your header or footer volition save automatically, and they'll as well be applied to whatever future copies of your Google Sheets spreadsheet that you print.


The to a higher place commodity may contain affiliate links, which help support How-To Geek.