Achieve Consistent Page Numbering (X of Y) Across Multiple Sheets

Published on

To achieve consistent page numbering (X of Y) across multiple sheets, you need to select all the sheet tabs you want to print. However, this process differs from Excel.

In Excel, you can select multiple spreadsheets for printing by selecting tabs from within the tab bar.

Use the Ctrl key to select multiple tabs by pressing and holding this key while selecting your desired tabs. If you want to select continuous tabs, press and hold the Shift key and select two sheets (from and to).

In Google Sheets, while you can similarly select multiple sheets, it does not impact the print settings.

So, how can you print sequential page numbers with multiple sheets in Google Sheets?

Google Sheets provides this feature directly within the print setup. Here are the steps to print continuous page numbers across sheet tabs in Google Sheets:

Print Settings for Continuous Page Numbers Across Sheets

I’ll take you straight to the settings:

  1. Open the Google Sheets file that you want to print. Ensure you are online while working in Sheets.
  2. Go to the File menu and click Print.
  3. In the Print settings panel on the right side of your screen, select “Workbook” under “Print”.
  4. Under “Selection”, choose “All sheets” if you want to print the entire file. Otherwise, select the individual tabs you want and click “Apply”.

The screenshot below may help you apply these print settings.

Select Multiple Sheets in Google Sheets

You’ve completed the essential steps. The remaining steps are straightforward:

  1. Click “Headers and footers”.
  2. Check the tickbox beside “Page numbers”.

This will enable continuous page numbers across sheet tabs in Google Sheets.

Add Page Numbers (X of Y)

You can insert three types of page numbers when printing a Google Sheets file:

  • [PageA] returns page numbers such as 1, 2, 3, …, which is the default format.
  • [PageB] returns page numbers such as Page 1, Page 2, Page 3, …
  • [PageC] returns page numbers such as Pg 1, Pg 2, Pg 3, …

To add page numbers in the format “Page X of Y” (e.g., Page 1 of 3, Page 2 of 3, Page 3 of 3), where Y represents the total number of pages and is dynamic, you should use the format [PageB] of [PageA]. Here’s how to set it up:

Deleting page numbers in Google Sheets
  1. Under “Headers and footers” (see step #5 above) in the Print settings, click the blue link “EDIT CUSTOM FIELDS” in the right-side panel.
  2. In the print preview, click on the page number field.
  3. Delete any existing placeholder text in the field (e.g., delete [PageA]).
  4. Click the Page Number option and select the formatting that shows “Page 1,” which will insert the placeholder [PageB].
    Page number formatting options in Google Sheets print setup
  5. Next to [PageB], type ” of “.
  6. Click on the “1” in the page number field, which will insert [PageA].
  7. Click on the content area (the grid area in the preview).
  8. Click the CONFIRM button.

This will insert page numbers in the format “Page X of Y” in your Google Sheets printouts.

Resources

Prashanth KV
Prashanth KV
Your Trusted Google Sheets and Excel Guide Prashanth KV brings a wealth of experience in Google Sheets and Excel, cultivated through years of work with multinational corporations in Mumbai and Dubai. As a recognized Google Product Expert in Docs Editors, Prashanth shares his expertise through insightful blogging since 2012. Explore his blog for practical tips and guidance on maximizing your spreadsheet skills.

Lookup Values Under Categories in Excel and Google Sheets

We can use a combination of XLOOKUP and VLOOKUP in both Excel and Google...

Extract Items Under a Category from the Same Column in Excel

In Excel, you can use a combination of the XLOOKUP and DROP functions to...

How to Create a Searchable Table in Excel Using the FILTER Function

Finding specific records, or rows containing the required information, is straightforward in Excel using...

Time Sequences in Excel by Minute, Hour, or Second Increments

Creating time sequences, whether by hour, minute, or second increments in Excel, can be...

More like this

XMATCH Row by Row: Finding Values Across a Range in Google Sheets

Using the BYROW function with XMATCH in Google Sheets allows us to match values...

Limit Formula Expansion to a Specific Row in Google Sheets

In this tutorial, I’ll explain how to limit the expansion of an array formula...

3-D Referencing Structured Data Tables in Google Sheets

When you have several tables within a single sheet—not across multiple sheets in a...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.