Printing Problems

How to Continue Excel Page Numbers Across Worksheets

Olivia Miller Oct 16, 2026 870 views

Question details

The user needs Excel page numbers to flow continuously across all worksheets in a workbook rather than restarting at page 1 for each new sheet.

How to Continue Excel Page Numbers Across Multiple Worksheets

Product: Excel
Device & OS: not provided
Scenario: Printing or exporting a multi-sheet Excel workbook as a single continuous document.
Observed behavior: When using the &[Page] header or footer code, Excel restarts the page numbering at 1 for every individual worksheet by default.

Before you start

Ensure that your computer has an active printer driver installed, as Excel's Page Setup and Header & Footer options rely on printer configurations to display properly.

Solution 1Recommended

Group Worksheets to Print as a Single Job

By grouping all relevant worksheets and printing them simultaneously, Excel treats the sheets as a single document and applies continuous page numbering automatically.

This is the most efficient method because it forces Excel's &[Page] code to calculate the total pages across all grouped sheets dynamically during the print process.

Select Multiple Worksheets

Hold down the 'Ctrl' key (or 'Shift' for consecutive sheets) and click the worksheet tabs at the bottom of your Excel window to group them. The selected tabs will turn white, and '[Group]' will appear in the title bar.

Insert Page Numbers

Navigate to the 'Insert' tab on the ribbon, click 'Header & Footer', and click inside the desired header or footer section. Click the 'Page Number' button to insert the '&[Page]' code.

Configure Page Setup

Go to the 'Page Layout' tab, click the small launcher arrow in the bottom-right corner of the 'Page Setup' group, and verify that 'First page number' is set to 'Auto'.

Print the Grouped Sheets

Press 'Ctrl + P' to open the Print menu. Ensure the print scope is set to 'Print Active Sheets'. When you print or export to PDF, the page numbers will continue sequentially across all selected sheets.

Group Worksheets to Print as a Single Job

Ungrouping Sheets: After printing, remember to right-click any sheet tab and select 'Ungroup Sheets' to prevent accidental data entry across multiple sheets simultaneously.

Solution 2

Manually Set the Starting Page Number for Subsequent Sheets

If you cannot print the worksheets as a single group, you can manually adjust the starting page number for each worksheet based on the total pages of the preceding sheets.

Efficient Spreadsheet Tool

Easily Manage Multi-Sheet Page Numbering with WPS Spreadsheet

WPS Office provides a highly compatible and intuitive Spreadsheet application that makes handling multi-sheet printing tasks effortless. You can easily group sheets and insert continuous page numbers using a clean, user-friendly interface.

1. Open Your Workbook: Launch WPS Office and open your multi-sheet spreadsheet document.
2. Group Worksheets: Hold the Ctrl key and click on the worksheet tabs at the bottom to select the ones you need to print together.
3. Insert Page Numbers: Go to the 'Insert' tab, select 'Header and Footer', and click the page number icon to add the &[Page] field.
4. Print Continuously: Click 'Print' or press Ctrl + P. Ensure 'Active sheets' is selected, and your pages will output with continuous numbering.

Fully compatible with Microsoft Excel (.xlsx, .xls) file formats.Intuitive Header & Footer settings for seamless page number management.Lightweight architecture processes complex multi-sheet printing jobs quickly.Free to download with comprehensive, professional spreadsheet functionalities.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the Header & Footer option unavailable or grayed out?

Excel relies on printer properties to calculate page layouts. If the Header & Footer option is grayed out, check that a printer driver is installed on your computer and set as the default printer. You do not need a physical printer connected, but a driver must be present.

Can I use the 'Page X of Y' format across grouped worksheets?

Yes. When you group multiple worksheets and print them as a single job, the &[Pages] code will automatically calculate the total number of pages across all the grouped sheets, meaning 'Page 1 of 10' will display correctly through the very last sheet.

Will continuous page numbering work if I save the workbook as a PDF?

Yes. If you group your worksheets first and then use the 'Save as PDF' or 'Export to PDF' feature, the resulting PDF document will maintain the continuous page numbering exactly as it would if you sent it to a physical printer.

How do I remove page numbers from my Excel worksheets?

To remove page numbers, go to the 'Insert' tab, click 'Header & Footer', click inside the header or footer section containing the numbering, and simply highlight and delete the &[Page] code. Click anywhere outside the header/footer area to apply the changes.

Document & File Issues