Unlike Microsoft Spreadsheet, Google Sheets don’t have a visible option to add a header or footer to your spreadsheet. It can be added when you decide to print your sheet.
The option is available in Printer’s settings menu. In this guide, we will show you how to add a header or footer in Google Sheets.
RELATED: How to Change Ruler Units in Word
Add Header or Footer in Google Sheets
Here’s how you can do it:
First, go to Google Sheets and open an already existing spreadsheet with data in it.
At the top of the sheet, select the “File” menu. From the drop-down list, click “Print” to view the printer’s settings menu for your document.
The print Settings menu will appear on the screen from where you can customize the layout and design to print the document according to your requirement. Here you can add a header and footer. Click the “Headers and Footers” drop-down option on the right of the menu.
A list of available options for both header and footers will appear. Check the box next to the option to enable it.
You can insert the page number, workbook title, sheet name, or the current date/time to your printed spreadsheet. Google will automatically determine whether to place these in the header or footer when printing.
By default, page numbers are automatically placed in the footer whereas workbook title in the header. If you want to change the positions or add custom text to the header or footer, click “Edit Custom Fields”.
You will now see a print view of your Google sheet. Here you can click any box to make changes to your header or footer.
To save the changes you just made, click “Confirm”.
Now click “Next” at the top right.
You’ll be taken to the Printing options where you can specify more print settings for your spreadsheet.