Printing with Custom Footers

I’m really looking forward to an upcoming print feature and print-to-pdf or save-to-pdf feature. I’m hoping that one of the options for printing will be to define a custom footer and/or header.

Some of the critical things for footers besides the very obvious “Page # of #” include branding, attribution, “Confidential” and similar labeling, URL, copyright, address/contact information.

Headers are also important for the same reason, and the ability to include an image (e.g. a logo for branding) would be a nice bonus. A separate header is not as critical as the footer IF you allow the user to choose a number of rows at the top to be printed on every page … but that doesn’t really allow you to use automated page numbering in a header.

One of the things Google Sheets lacks is the ability to choose the font color for footers. For example, you’d want to choose red for a “Confidential” notice or gray for text when you don’t want to draw too much attention.

I’ve always liked how Excel and GS give you the option to enter footer info into a left, center, or right section.

While I’m adding to my wish list for print settings … the ability to define custom margins is also very important (I’d take a Standard/Narrow option for margins if custom is not possible, where narrow is usually around 0.35" to 0.4", 0.9 to 1.0 cm, though most good printers can print more narrow than that). The ability to scale the print area to fit on a particular number of pages is also critical for spreadsheets.

2 Likes

All very practical and desirable requests as usual. :blush:

First release of print is just around the corner. I can confirm that it will support:

  • Print - which opens up the content in browser’s native print dialog to be sent to a printer
  • Download as PDF that allows the same content to be downloaded as a PDF file
  • Limited header and footer options like workbook/sheet title in the header, page number (alone as well as # of # format, date and/or time of generation)
  • Margins will have option of narrow (0.25" left/right), normal (0.7" left/right), wide (1" left/right). Custom margins is on the roadmap but not part of first release
  • Fit to width that squeezes all columns in the sheet into a single page, will be available

Most of the things that you mention are on the print enhancement roadmap (near or far). Have taken note of some interesting suggestions (branding/attribution/et al) and will run it through the chain.

4 Likes

Thank you for the update.