Create custom headers and footers in Google Sheets

You can now customize the headers and footers when printing in Google Sheets. 

Add the text of your choosing along with selecting from pre-defined options such as a date, time, etc. and then move those options around within your header and footer. 

You can also save your print settings. Just modify your settings once, and they’ll be retained the next time you, or a collaborator, opens that same spreadsheet.

Simply choose “EDIT CUSTOM FIELDS” from the Print settings menu to get started.