A Google Sheets spreadsheet doesn’t have a visual header or footer till you determine to print. If you wish to add headers and footers to a Google Sheets spreadsheet, you’ll have to make use of the printer settings menu—right here’s how.
To start, open the Google Sheets spreadsheet that accommodates your information. On the prime, click on File > Print to view the printer settings menu on your doc.
Within the “Print Settings” menu, you possibly can customise the structure and design of your spreadsheet to make it appropriate for printing. So as to add a brand new header or footer, click on the “Headers and Footers” class within the menu on the proper.
A listing of obtainable choices for each headers and footers will seem. Click on the checkbox subsequent to a preset choice (for instance, “Web page Numbers”) to allow it.
You may add web page numbers, a workbook title, sheet title, or the current date or time to your printed spreadsheet. Google mechanically determines whether or not to put these within the header or footer.
For instance, web page numbers are mechanically positioned within the footer, whereas a workbook title can be positioned within the header. If you wish to change the place of a preset choice or add any customized textual content to a header or footer, click on “Edit Customized Fields.”
The print view on the proper will change and will let you edit the textual content containers within the header or footer. Click on a field to make any modifications to your header or footer.
Whenever you’re prepared to save lots of your modifications, click on “Verify” on the prime proper to return to the “Print Settings” menu.
In case you’re proud of the modifications you made to your header or footer, click on “Subsequent” on the prime proper.
You’ll now be taken to your browser or working system’s printer choices menu. Right here, you possibly can specify extra print settings on your spreadsheet, just like the variety of copies you wish to print.
The modifications you made to your header or footer will save mechanically, they usually’ll even be utilized to any future copies of your Google Sheets spreadsheet that you just print.