How to Print Excel Invoices with Automatically Increasing Numbers
Question details
The user needs to repeatedly print a multi-page Excel document while having the invoice or serial number increment automatically for each printed copy.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Batch printing invoices, receipts, or forms that require sequential serial numbering.
- Observed behavior
- Excel does not natively increment a cell value between print jobs without manual intervention, custom formulas, or VBA macros.
Before proceeding, decide whether you need a simple formula-based workaround for a small number of pages or a fully automated VBA macro for large-scale batch printing. Always save a backup of your workbook before running any macros.
Use a Custom Formula to Generate Sequential Numbers
This method is best for users who prefer not to use macros. It involves duplicating the invoice template and using a formula to increment the number automatically across rows.
Since Excel lacks a built-in 'print sequential numbers' button, you can create multiple copies of your invoice on a single worksheet. By using row-based formulas, each copied invoice will automatically generate the next number in the sequence.
Click on the specific cell in your invoice template where you want the sequential number to appear.
Input a formula such as =TEXT(ROW()-1,"0000") or =CONCATENATE("000",INT(ROW()/51)+1) depending on your row layout. This forces the number to display with leading zeros, like 0001.
Copy your entire invoice layout and paste it directly below the original. The formula will automatically adjust based on the new row number, incrementing the invoice number to 0002.
Highlight the range covering all the duplicated invoices you want to print. Go to File > Print, and under the print settings, choose 'Print Selection'.

Automate Sequential Printing with a VBA Macro
Ideal for printing hundreds of copies without manually duplicating the template, this method uses a script to increment the cell value and trigger a print job sequentially.
Automate Invoice Batch Printing Easily with WPS Spreadsheet
WPS Spreadsheet fully supports advanced formulas and VBA macros, making it incredibly easy to manage automatic numbering and batch print large quantities of invoices without formatting issues.
- 1. Open your Template: Launch WPS Spreadsheet and open your existing invoice or receipt document.
- 2. Apply Automation: Use custom sequential formulas or open the built-in Macro editor to write a quick loop script.
- 3. Print the Invoices: Navigate to the Print menu to verify the preview, then output your sequentially numbered files directly to your printer.

Frequently Asked Questions
Can I make Excel automatically increase an invoice number every time I open the file?
Yes, you can achieve this by using a 'Workbook_Open' VBA macro. The script can be written to automatically add 1 to the specific invoice cell value and save the file the moment it is opened.
Why do the leading zeros disappear when I type an invoice number like 0001?
Excel treats numbers with leading zeros as standard integers and removes them automatically. To keep the zeros, you must format the cell as Text before typing, or apply a custom number format like '0000'.
Is there a built-in Excel feature to print sequential numbers without formulas or macros?
No, Excel does not have a native feature or button strictly for printing sequentially incremented numbers on the same page layout. You must rely on either manual duplication with formulas or VBA macros for this specific workflow.




