How to Print Multiple Sheets in Excel at Once (or All Sheets)

When you want to print your work, Excel provides you with a variety of possibilities. You have the option of printing the worksheet as its whole, only a portion of it, several sheets, or all sheets at once.

I’ll demonstrate how to print many Excel sheets at once in this tutorial. These might be all of the workbook’s sheets or just a few particular ones.

Additionally, you may use a little VBA magic to print a specified region across multiple/all pages.

then let’s get going!

This instruction explains: 1. Print Every Sheet at Once 2. Print Several Sheets (Selected) in One Session 3. Print Numerous Sheets in a Particular Print Area 3.1 manually adjusting the print area 3.2 Using VBA, changing the Print Area

1. Print Every Sheet at Once

You may select to print all of the sheets at once using an Excel function.

The steps to print every sheet in the workbook are listed below:

1. Go to the File tab.
2. Press the Print button.
3. Click the Print setting drop-down menu on the Print page.
4. The Print setting drop-down may be found on the Print page.
5. Select Print.

The aforementioned actions would print every sheet in the workbook. Only the print area that you have designated in some of the sheets will be printed.

Additionally, the Print preview on the right lets you see what will be printed. Changing the page numbers will allow you to see what will be printed on each page.

Simple enough!

What if you want to print just a few certain sheets, not the complete workbook?

Read on!

2. Print Several Sheets (Selected) in One Session

This is also pretty simple to accomplish.

You only need to pick the exact papers you wish to print before doing so.

The procedures to print particular Excel workbook sheets are listed below:

1. Choose every sheet you wish to print. Holding down the Control key will allow you to choose sheets one at a time. In this instance, I’ve chosen Sheets 1, 4, and 5.
2. Go to the File tab.
3. Press the Print button.
4. Click the Print setting drop-down menu on the Print page.
5. Click Print Active Sheets (that should be the default setting in most circumstances, but you may change it using the drop-down menu).
6. Select Print.

Multiple sheets are selected, and upon printing, all of them become active sheets.

Additionally, the Print preview on the right lets you see what will be printed. Changing the page numbers will allow you to see what will be printed on each page.

3. Print Numerous Sheets in a Particular Print Area

The third one is a little trickier than the first two.

Let’s say you want to print a specified region from each page in a workbook that has numerous sheets.

Perhaps each page has summary data, and you want to print just this information rather than the worksheet as a whole.

Setting a print area on each page and printing it will do this (as shown in the above two methods).

To set the print area, do the following:

• Each sheet has to be individually processed (especially if the print area is different for each sheet)
• Alternately, you may specify the same print area in all of the pages at once using a straightforward VBA code.

You can print the sheets using any of the aforementioned techniques after setting the print area.

So allow me to briefly demonstrate how to manually adjust the Print area using VBA.

3.1 manually adjusting the print area

The procedures are as follows:

1. In the print area, choose the cells you wish to be covered.
2. Toggle to the “Page Layout” tab.
3. Click on “Print Area” in the Page Setup group. ’
4. Select “Set Print Area”

I’m done now!

When you print this page, just the print area will be shown since the print area will be set to the specified cells.

Each sheet must be individually processed in this manner. As a result, you will need to print certain regions on Sheet 1, Sheet 4, and Sheet 5 individually.

3.2 Using VBA, changing the Print Area

Setting the print area manually might be time-consuming if you have several worksheets.

The print area may then be rapidly configured in one sheet using VBA, and all the other sheets can then have it set similarly by running the code.

Note: This approach works best when the range of cells you wish to utilize to set the Print Area are the same.

The VBA macro code for doing this is provided below:

Sub SetPrintAreas1()
    Dim PrntArea As String
    Dim ws As Worksheet
    PrntArea = ActiveSheet.PageSetup.PrintArea
    For Each ws In Worksheets
        ws.PageSetup.PrintArea = PrntArea
    Next
    Set wks = Nothing
End Sub

The code mentioned above establishes the identical print area in each of the workbook’s sheets by using the active sheets’ print area as a starting point.

Each worksheet is traversed using a loop, after which the identical area in each worksheet is assigned as the print area. I think it would be quicker to do it manually if you wanted this to be different for each sheet.

Once you have this set, all of the sheets (or just a few of them) can be printed, and only the print area will be reproduced.

This VBA macro code may be placed in a standard module and executed there.

These are some situations when printing several Excel sheets at once is possible.

I hope this instruction was helpful.