Formatting Issues

How to Start Excel Page Numbers After the First Four Pages

Muhammad TalhaMuhammad Talha Nov 2, 2026 870 views

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.

How to Start Excel Page Numbers After the First Four Pages
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 you start

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.

Solution 1Recommended

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.

1
Move introductory data

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".

2
Configure the numbered worksheet

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.

3
Set the starting number

In the same "Page Setup" dialog, switch to the "Page" tab. Change the "First page number" setting from "Auto" to "1" and click "OK".

4
Print both sheets

Print the "Front Pages" worksheet first. Then, select your original worksheet and print it. The resulting physical stack will have the correct numbering.

Split Content into Separate Worksheets
Tip: If you need to distribute this document digitally as a PDF, you can select both worksheets simultaneously (hold Ctrl and click the sheet tabs) and save as PDF to create a single continuous file.
WPS Spreadsheet Solution

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. 1. Open your file in WPS: Launch WPS Spreadsheets and open your multi-page workbook.
  2. 2. Print the first batch: Go to "Menu" > "Print", select pages 1 to 4, and print them without page numbers applied.
  3. 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. 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.
Fully compatible with Microsoft Excel (.xlsx, .xls) files and formatting.Intuitive Page Setup dialog for custom page numbering offsets.Free and lightweight alternative for daily office tasks.Built-in PDF conversion to combine split worksheets into a single document.
microsoft office alternative - wps office

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.