How to Start Excel Page Numbers After the First Four Pages
Question details
The user wants to start printing an Excel worksheet with page numbering beginning at "1" on the fifth printed page, leaving the first four pages unnumbered.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Preparing a multi-page Excel document for printing where introductory pages (like a title page or table of contents) should not be numbered, but the core data starting on page 5 should begin at page 1.
- Observed behavior
- Excel does not have Word-style section breaks to restart page numbering on a specific page. Page numbering applies continuously to the entire worksheet, requiring a workaround to achieve the desired output.
Before applying these print workarounds, finalize your worksheet's column widths, row heights, and margins to ensure the data breaks exactly where you expect across the printed pages.
Split Content into Separate Worksheets
The most reliable method is to separate the unnumbered introductory pages and the numbered data pages into two different worksheets with distinct page setups.
By dividing your data across two sheets, you can independently control the headers and footers for each section without affecting the other.
Select the rows containing the data for your first four pages. Right-click and choose "Cut", then paste this data into a new worksheet named "Front Pages".
Return to your original worksheet, which now begins with the data for page 5. Go to the "Page Layout" tab, click the dialog box launcher in the "Page Setup" group, and navigate to the "Header/Footer" tab to insert your page numbers.
In the same "Page Setup" dialog, switch to the "Page" tab. Change the "First page number" setting from "Auto" to "1" and click "OK".
Print the "Front Pages" worksheet first. Then, select your original worksheet and print it. The resulting physical stack will have the correct numbering.

Print in Batches Using a Negative First Page Number
This clever workaround avoids splitting your data by adjusting the starting page number backward and printing the document in two separate batches.
Hide Rows Using Page Break Preview
You can temporarily hide the rows belonging to the first four pages so that Excel only "sees" and numbers the remaining pages.
Easily Batch Print and Manage Page Setups in WPS Spreadsheets
You can seamlessly perform these print workarounds using WPS Spreadsheets. It offers an intuitive Page Layout interface to quickly manage custom print settings, headers, footers, and page numbers while maintaining 100% compatibility with your Excel files.
- 1. Open your file in WPS: Launch WPS Spreadsheets and open your multi-page workbook.
- 2. Print the first batch: Go to "Menu" > "Print", select pages 1 to 4, and print them without page numbers applied.
- 3. Adjust the page setup: Navigate to the "Page Layout" tab and click the "Page Setup" icon. Under the "Header/Footer" tab, add your page numbers.
- 4. Offset the numbering and print: In the same dialog, click the "Page" tab and set "First page number" to -3. Finally, print from page 5 onward via the Print menu.

Frequently Asked Questions
Why doesn't Excel have section breaks like Microsoft Word?
Excel is designed primarily for continuous data calculation and grid-based analysis rather than complex text document layout. While Word handles continuous text flow with distinct section breaks for formatting, Excel treats each worksheet as a single continuous grid, applying one consistent header and footer per sheet.
Can I remove the page number from only the first page in Excel?
Yes. You can go to "Page Layout" > "Page Setup" > "Header/Footer" and check the box for "Different First Page". This allows you to leave the first page header or footer completely blank while continuing sequential numbering on the rest of the worksheet.
Will hiding rows to print affect my spreadsheet's formulas?
Hiding rows will not delete your data or break standard formulas like SUM or VLOOKUP. However, if you are using specific functions designed to ignore hidden rows, such as SUBTOTAL or AGGREGATE, those particular formulas will recalculate based only on the visible cells.
How do I force a page break exactly where I want it?
To manually control where a page ends, click on the row below where you want the break to happen, navigate to the "Page Layout" tab, click "Breaks", and select "Insert Page Break". You can view and adjust these easily by switching to "Page Break Preview" under the View tab.




