I just has a header to my Google Sheets like this:

How do I now change the size or color of these texts?

Thanks for your help!


1 Answer 1


At this time the feature to customize headers and footers doesn't include a way to set a custom formatting (font, color, size, effects like bold, italics, etc.).

One alternative is to use rows to hold the header / footer text and use the cell formatting or in cell text formatting to customize the "headers" and "footers"

Related Q&A: Adding a header and footer to a Google Spreadsheet

Related Help Article: Add headers, footers & page numbers

  • Dear Rubén Thank you very much for your tip! I was able to use the first rows for the header, freezing them and using the printing options. But how can I do the same for the footer?
    – Ceu Melo
    Feb 23, 2018 at 15:04
  • @CeuMelo AFAIK it's not possible to freeze non-consecutive rows and I never tried to use row freezing for footers, so I don't know (at this time).
    – Rubén
    Feb 23, 2018 at 15:14

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.