Printing Problems

How to Print Excel Invoices with Automatically Increasing Numbers

Guest WriterGuest Writer Oct 10, 2026 875 views

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.

How to Print Excel Documents with Automatically Increasing Invoice Numbers
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 you start

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.

Solution 1Recommended

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.

1
Select the Invoice Number Cell

Click on the specific cell in your invoice template where you want the sequential number to appear.

2
Enter the Sequential Formula

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.

3
Duplicate the Invoice Template

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.

4
Print the Selected Range

Highlight the range covering all the duplicated invoices you want to print. Go to File > Print, and under the print settings, choose 'Print Selection'.

Use a Custom Formula to Generate Sequential Numbers
Adjusting the Formula: If your invoice template spans multiple rows (e.g., 50 rows per invoice), you will need to adjust the math in the formula, such as INT(ROW()/50)+1, to ensure the number only increments once per page.

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. 1. Open your Template: Launch WPS Spreadsheet and open your existing invoice or receipt document.
  2. 2. Apply Automation: Use custom sequential formulas or open the built-in Macro editor to write a quick loop script.
  3. 3. Print the Invoices: Navigate to the Print menu to verify the preview, then output your sequentially numbered files directly to your printer.
100% compatible with Microsoft Excel (.xlsx and .xlsm) files and VBA macros.Advanced print preview and layout settings for precise invoice formatting.Lightweight architecture ensures smooth performance during bulk print jobs.Free to download and provides a highly intuitive user interface.
microsoft office alternative - wps office

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.