Printing Problems

How to Print Each Excel Customer Report on Separate Pages in Excel 365

Emma BrownEmma Brown Nov 13, 2026 868 views

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.

How to Print Each Excel Customer Report on Separate Pages
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the VBA editor

In Excel, press Alt + F11 to open the Visual Basic for Applications editor.

2
Insert a new module

Click Insert > Module in the VBA editor menu to create a blank module.

3
Paste the print macro

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

4
Run the macro

Press F5 or click Run > Run Sub/UserForm. Excel then sends each worksheet to the printer as a separate print job.

Print Each Worksheet as a Separate Job with a VBA Macro
Reports stay separate: Each customer worksheet prints as its own job, so a customer report starts on a new sheet of paper even when the previous report has an odd number of pages.
WPS Spreadsheets direct solution

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. 1. Open the workbook in WPS Spreadsheets: Launch WPS Office Spreadsheets and open the Excel customer workbook that contains the 50+ worksheets.
  2. 2. Open the macro editor: Go to Tools > Macro > VBA Editor or use the Developer tab, then insert a new module.
  3. 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. 4. Run the print job: Run the macro to send each worksheet to the printer as an independent print job.
  5. 5. Check the output: Confirm that each customer report starts on a new sheet of paper, even after odd-page reports.
Prints each customer worksheet separately so odd-page reports do not run into the next customer.Opens .xlsx files with full Microsoft Excel format compatibility.Provides a free, lightweight Office suite with familiar spreadsheet, print, and macro tools.Makes it easy to manage more than 50 customer report sheets without changing the workbook structure.
microsoft office alternative - wps office

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.