I can select to show page number in Google Sheets print options. However, what I want is to have "Page X of Y", e.g. "Page 1 of 5".

Is it at all possible to do in Google Sheets?

  • Seems to be still a missing feature by April 2020. – Avatar Apr 27 '20 at 15:22

Under Print > Headers & footers there is an option to add Page numbers. It is a field that will increment as additional pages are printed. As far as I am aware there is no equivalent field for the total number of pages (in Sheets), but this may be added (along with of) through EDIT CUSTOM FIELDS. There Page or Pg may also be added, either in the same way or by editing the field choice (click on the left hand icon).

![Print screen

The previous screen should display the total number of pages to expect (top left).

  • 1
    This is a useful workaround, but you have to remember to check the footer every time you print the sheet. – Paddy Landau Apr 10 '20 at 14:40

After adding the page numbers to the footer (or header), double click the footer and after the page number add "of" then go to the "Insert Tab - Page numbers - Page count. Its done.

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.