I read on here how to use the script =sheetName() to display the sheet name, but is there another script I can use to display the workbook title?

I use daily sheets and the title for the sheets are the date. When I print them, I want it to display the date (located in the title).
(I know I can show the title in the print settings but that's a lot of steps if I'm mass printing)


Use the getName() method from the Class Spreadsheet.

We don't need a script to display the Spreadsheet title when printing.

  1. Click on File > Print
  2. On the right panel, expand the Headers & footers section
  3. Check the Workbook title to add it to the default field or click on Edit Custom Fields to add it to the field that prefer.
  • Thanks for the help but I already said that I knew that option. I'm trying to find a way that it auto inserts the title in a cell so I don't have to go in the print options for each and every sheet.
    – Justin
    Jan 16 '18 at 17:43
  • @Justin: You edited your question to said that 5 minutes ago :)
    – Rubén
    Jan 16 '18 at 17:51
  • Yes, I was just making it more clear for future readers.
    – Justin
    Jan 17 '18 at 12:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.