How to Print Each Excel Customer Report on Separate Pages in Excel 365
Question details
The user needs to print more than 50 customer worksheets from an Excel 365 workbook so each customer's report starts on a new sheet of paper, even when the previous report ends on an odd page.

- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- The user manages a multi-customer workbook with more than 50 worksheets and needs to print all reports without merging odd-page reports.
- Observed behavior
- Printing the entire workbook as one continuous job can make the next customer report start on the wrong side or follow immediately after an odd-page report instead of starting on a fresh sheet.
Open the workbook and review each customer worksheet's print area, page orientation, margins, scaling, and paper size. If you plan to run a VBA macro, save the file as an Excel Macro-Enabled Workbook (.xlsm) first.
Print Each Worksheet as a Separate Job with a VBA Macro
Use this method when you have many worksheets and need every customer report to start on a fresh sheet of paper, because the macro calls each worksheet's PrintOut method individually.
Printing the workbook as one continuous job can tie all sheets together. A short VBA loop prints every worksheet one at a time, so the printer treats each customer report as an independent job.
In Excel, press Alt + F11 to open the Visual Basic for Applications editor.
Click Insert > Module in the VBA editor menu to create a blank module.
Paste the following macro into the module: Sub PrintEachWorksheet() Dim wsh As Worksheet For Each wsh In ThisWorkbook.Worksheets wsh.PrintOut Next wsh End Sub
Press F5 or click Run > Run Sub/UserForm. Excel then sends each worksheet to the printer as a separate print job.

Manually Print Each Customer Worksheet One at a Time
Use this approach when macros are unavailable or when you want to visually confirm each report before printing.
Print Each Customer Worksheet as a Separate Job in WPS Spreadsheets
Open the same Excel workbook in WPS Spreadsheets and use the VBA-style macro or the Print Active Sheet option to print customer worksheets independently, keeping each report on a fresh page.
- 1. Open the workbook in WPS Spreadsheets: Launch WPS Office Spreadsheets and open the Excel customer workbook that contains the 50+ worksheets.
- 2. Open the macro editor: Go to Tools > Macro > VBA Editor or use the Developer tab, then insert a new module.
- 3. Paste the print loop: Paste the same macro: Sub PrintEachWorksheet() Dim wsh As Worksheet For Each wsh In ThisWorkbook.Worksheets wsh.PrintOut Next wsh End Sub
- 4. Run the print job: Run the macro to send each worksheet to the printer as an independent print job.
- 5. Check the output: Confirm that each customer report starts on a new sheet of paper, even after odd-page reports.

Frequently Asked Questions
Why should I print each worksheet separately instead of printing the entire workbook?
Printing the entire workbook can send all sheets as one continuous job, which may cause an odd-page customer report to run into the next report. Printing each worksheet separately makes each customer report an independent job that starts on a fresh sheet.
Does the PrintOut macro work in WPS Office Spreadsheets?
In WPS Spreadsheets editions with VBA or macro support, open Tools > Macro > VBA Editor, insert a module, paste the loop, and run it. If your edition does not support VBA, print each customer sheet manually with File > Print > Print Active Sheets.
How do I prevent a customer report from being cut off across pages?
Before printing, select the report range, go to Page Layout > Print Area > Set Print Area, and use Page Setup > Scaling > Fit to 1 page wide to keep columns on the page.
Do I need to save the workbook as .xlsm to keep the macro?
In Excel, save the workbook as an Excel Macro-Enabled Workbook (.xlsm) so the VBA macro is retained. In WPS Spreadsheets, use a macro-enabled format where available, or open the original workbook and run the macro without changing the source file.




