How to Insert Headers and Footers in Google Sheets

This practical guide walks through how to insert headers and footers in Google sheets, explains the main requirements, and highlights common issues that may appear along the way.

On the online spreadsheet tool Google sheets, Headers, and Footers are only displayed until you decide to print the sheet. To add Headers and Footers to your Google sheets, you'll have to use the printer settings menu. Here's how.

Insert Headers, Footers in Google sheets

First, open a Google sheets spreadsheet containing the data to create Headers, Footers. From the top toolbar, navigate to File> Print to access the print settings menu for the document.

In the " Print Settings " menu , you can customize the layout and design of the spreadsheet to suit your printing purposes. To add new Headers or Footers, click on the category ' Headers and Footers ' in the right menu.

A list of options available for both Headers and Footers will appear. Click the checkbox next to an available option (for example, 'Pages') to turn it on.

You can add the page number, workbook title, sheet name, or current date and time to your printed spreadsheet. Google will automatically determine whether these should be placed in the header or footer.

For example, the page number is automatically placed in the footer, while the workbook title will be placed on top. To change the position of an option or add any custom text to Headers or Footers, click ' Edit Custom Fields '.

The print view on the right side of the screen will change and allow you to edit text fields in Headers or Footers. Click each text field to make any changes you want.

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

When you are satisfied with the changes made to Headers or Footers, click ' Next ' at the top right.

You will now be taken to the printer options menu of your browser or operating system. Here, you can specify more printing settings for your spreadsheet, such as the number of copies you want to print.

Changes you make to Headers or Footers are automatically saved, and they will be applied to any copies you print in the future.