Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm in the process of changing to Google Drive from MS Office for all aspects of my work. Pretty much everything I need is there, but the one thing we can't work out how to do is how to get a header and footer into a Google Spreadsheet (although we have them working fine in Word documents).

Is there an approach to do this? Also, it's worth pointing out this is mainly for use when we export our spreadsheets as PDF's. So the other thing that would be great, is to be able to view the page breaks, as you can in MS Excel.

share|improve this question
up vote 3 down vote accepted

There exists no direct way to add a header and footer to a Google Spreadsheet.

Two pis-allers to add a header:

  • use the filename as the header
  • use a row header and check the "repeat row headers on each page" in the print settings.

As for the footer, you are screwed.

Lastly, it's not possible to view the page breaks.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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