How to Print Multiple Worksheets at Once in Excel?

Sharing is caring!

Microsoft Excel makes data management easier by allowing users to organize information into multiple worksheets within a single workbook. But when it comes to printing multiple sheets, many users manually print one sheet at a time which can be frustrating and time-consuming. Luckily, Excel provides built-in options to print multiple worksheets at once efficiently.

In this guide, we will explain step-by-step methods to print all or selected worksheets in one go. You’ll also learn useful print settings, page setup tips, and shortcuts that make printing in Excel smoother.

Understanding Worksheets and Workbooks in Excel

Before printing multiple worksheets, it’s important to understand the structure of an Excel file.

When you open Excel, you work within a workbook, and each sheet (like Sheet1, Sheet2, etc.) is a worksheet. Printing multiple worksheets means Excel will process each selected worksheet as a separate printable page – all in one command.

Method 1: Print All Worksheets in a Workbook

If you want to print the entire workbook (all sheets), Excel provides a direct option.

Steps to Print All Worksheets at Once

1. Open your Excel workbook that contains multiple worksheets.
2. Click on the File tab in the ribbon.
3. Select Print from the left-hand menu (or press Ctrl + P).
4. Under the Settings section, click the drop-down menu that says Print Active Sheets.
5. Choose Print Entire Workbook.
6. Review the print preview on the right.
7. Click Print to start printing all worksheets.

This option sends all worksheets to the printer sequentially, keeping each worksheet’s content on separate pages.

Method 2: Print Selected Worksheets Only

If you don’t want to print every worksheet, you can select specific sheets and print them together.

Steps to Print Multiple Selected Worksheets

1. Hold down the Ctrl key (or Command key on Mac).
2. Click the worksheet tabs you want to print.
3. Go to the File tab → Print.
4. Ensure Print Active Sheets is selected under the Settings section.
5. Review the preview to confirm which sheets are included.
6. Click Print.

Excel treats all selected worksheets as active sheets, printing them together as one print job.

Method 3: Using Right-Click Menu to Print Selected Sheets

There’s also a quicker way to print multiple worksheets directly from the tab area.

1. Press and hold Ctrl while selecting the worksheet tabs you want.
2. Right-click on any selected tab.
3. Choose Print from the context menu.

This shortcut immediately opens the print window for your selected sheets — ideal for quick printing tasks.

Method 4: Print Multiple Worksheets Using VBA

If you regularly need to print the same worksheets, using a VBA macro can automate the process.

Example VBA Code

Sub PrintSelectedSheets()
    Sheets(Array("Sheet1", "Sheet3", "Sheet5")).PrintOut
End Sub

How it works:

• Replace “Sheet1”, “Sheet3”, “Sheet5” with the names of your worksheets.
• This macro automatically prints the specified sheets in one click.

To use this macro:

1. Press Alt + F11 to open the VBA editor.
2. Go to Insert → Module.
3. Paste the code.
4. Close the editor and run the macro (press Alt + F8).

This is especially helpful in business reports, invoices, or financial templates where the same sheets are printed regularly.

Method 5: Print Entire Workbook with a Keyboard Shortcut

Excel doesn’t have a default single-key shortcut for printing all sheets, but you can combine a few keys:

1. Press Ctrl + P to open the Print window.
2. Press Alt + W to select Print Entire Workbook (in most versions).
3. Press Enter to print.

This combination quickly prints your full workbook without using the mouse.

Method 6: Group Worksheets Before Printing

Another practical technique is grouping worksheets. This lets you apply same formatting and print settings simultaneously.

How to Group Worksheets

1. Hold Ctrl and click all worksheet tabs you want to group.
2. Notice “[Group]” appears in the workbook title bar.
3. Adjust any page layout settings (like orientation or scaling).
4. Go to File → Print → choose Print Active Sheets.
5. Click Print.

After printing, right-click any sheet tab and choose Ungroup Sheets.

Troubleshooting Common Printing Issues

When printing multiple worksheets, you may face alignment or formatting issues. Here’s how to fix them:

Tips for Printing Multiple Worksheets Efficiently

Here are some pro tips to make your printing tasks faster and cleaner:

• Preview before printing: Always check print preview for every sheet to avoid wasted paper.
• Set a print area: Highlight specific ranges using Page Layout → Print Area → Set Print Area.
• Use PDF printer: If you just need a soft copy, choose Microsoft Print to PDF to save all sheets as a single PDF file.
• Rename worksheets: Use meaningful names like “Sales_Q1,” “Sales_Q2,” etc., to identify sheets easily during printing.
• Avoid blank sheets: Delete unused sheets to prevent printing empty pages.

Example: Printing Multiple Financial Reports

Let’s consider an example where a company has different financial statements in separate sheets:

To print all reports together:

1. Hold Ctrl and select the four sheet tabs.
2. Go to File → Print.
3. Select Print Active Sheets.
4. Confirm layout and scaling.
5. Click Print.

Excel will print all four sheets sequentially; each with consistent headers, margins, and formatting.

Final Thoughts

Printing multiple worksheets at once in Excel is a major time-saver, especially when handling large datasets, reports, or multi-sheet summaries. By using Print Entire Workbook, grouping sheets, or VBA automation, you can handle your print tasks efficiently.

Before printing, always preview your sheets, align page settings, and ensure consistent formatting for professional results.

FAQs

Vaishvi Desai

Vaishvi Desai is the founder of Excelsamurai and a passionate Excel enthusiast with years of experience in data analysis and spreadsheet management. With a mission to help others harness the power of Excel, Vaishvi shares her expertise through concise, easy-to-follow tutorials on shortcuts, formulas, Pivot Tables, and VBA.