How to Print Multiple Sheets in Excel (6 Suitable Examples)

Get FREE Advanced Excel Exercises with Solutions!

Microsoft Excel allows us to print the data as per our wish. There are so many options available while printing multiple sheets at a time in Excel. In this article, we will describe how to print multiple sheets in Excel.

Below we have attached the image of the most common way to print all sheets at once.

How to Print Multiple Sheets in Excel


How to Print Multiple Sheets in Excel: 6 Suitable Examples

Excel has a built-in feature with which we can print the whole workbook together. Also, there are so many ways we can print Excel multiple sheets. So, let’s have a look at all the different ways to print multiple sheets in Excel.


1. Print All Sheets at Once in Excel

Suppose we have five sheets in our workbook, and we want to print all the sheets in one go. To print all sheets at once. Below, we have explained four ways to do so.


1.1. Using Print Entire Workbook Feature for Printing All Sheets at Once

Here, we will use the Print Entire Workbook feature for printing all sheets at once.

  • First, go to the File tab on the ribbon or press CTRL+P. This will take us to the main menu.

Opening File tab

  • After that, from the Print option >> go to the Settings drop-down menu >> then select Print Entire Workbook >> just click on the Print button.

And there you go! By following these instructions, you can print the entire workbook in just one go.

How to Print Multiple Sheets in Excel

Read More: [Fixed!] Cutting Off Text When Printing in Excel


1.2. Use of VBA Code to Print the Entire Workbook

We can use VBA Macros to print the entire workbook at once. For this, we need to follow the procedure down.

  • First, go to the Developer tab on the ribbon >> click on Visual Basic to open the Visual Basic Editor where we will write the VBA codes. Another way to open the Visual Basic Editor is simply to press ALT+F11.

Opening Visual Basic Editor

  • Next, go to Insert and select Module from the drop-down menu.

Inserting Module

  • After that, copy and paste the VBA code in Module >> click on the RUN button to run the code.

Running the VBA Code to Print Multiple Sheets

VBA Code:

Sub Print_Workbooks()
  ActiveWorkbook.PrintOut
End Sub

Finally, by running the code, we can easily print the entire workbook.


1.3. Converting Excel File into PDF File with VBA Code to Print All Sheets

Here, we will convert the Excel file into a single PDF file by using the Excel VBA. Then we will print that PDF file. Simply just follow the below instructions.

  • Go to the Developer tab >> Visual Basic >> Insert >> Module.
  • Now, copy and paste the VBA code that is shown below.

Converting Excel File into PDF File with VBA Code

VBA Code:

Sub PrintAllSheetToPdf()
For Each iSheet In ActiveWorkbook.Worksheets
Worksheets(iSheet.Name).Select False
Next iSheet
With Application.FileDialog(msoFileDialogFolderPicker)
.Show
iFolder = .SelectedItems(1) & "\"
End With
iFile = InputBox("Enter New File Name", "PDF File Name")
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=iFolder & iFile, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True
End Sub
  • Now, press F5 on your keyboard >> After successful code execution, you will be asked to select the folder where you want to save the PDF file >> After selecting the new file path, click OK.

Choose a Folder to keep the PDF file

Then, a pop-up input box will appear. It will ask you for a name.

  • Write any name for your new PDF file. In our case, we named our new PDF file “PrintAllSheet”.
  • Later, click OK.

While you are doing these, you will notice that all the sheets in your workbook are automatically selected.

Write a name for the PDF File

Then you will get the PDF file, where each page of the PDF file will carry the data from each of the worksheets from the Excel workbook.

  • Then open the PDF file >> press CTRL+P >> then you can modify the page setup according to your need >> after that press Print.

Read More: [Fixed!] Excel Cutting Off Text When Printing to PDF


1.4. Print Some Certain Sheets by Using VBA Code

We can also print multiple sheets using the VBA Macros. Basically, we are going to print some defined sheets with a VBA code.

  • Likewise, in the previous method, to open the Visual Basic Editor, first go to the Developer tab on the ribbon >> click on Visual Basic >> from Insert >> select Module >> Now, write down the below VBA code.

Print Some Certain Sheets by Using VBA Code in Excel

VBA Code:

Sub Print_Certain_Sheets()
  Worksheets(Array("Apparel-1", "Grocery")).PrintOut
End Sub

Here, Apparel-1, and Grocery are the name of the sheets. Run the code by clicking the RUN button. In the end, running the code will print multiple sheets (Apparel-1, and Grocery) at one click.

Read More: [Fixed!] Excel Cutting Off Columns When Printing


2. Print Multiple Active Sheets

Here, we have five sheets of data but there are only three active sheets, and we want to print only those active sheets together.

  • To activate more than one sheet at a time, hold down the CTRL key >> then select the sheet name one by one.

Activate more than one sheet at a time

Now, let’s talk about how you can print these activated sheets at once.


2.1. Use of Print Active Sheets Feature for Printing Multiple Sheets

  • First, press CTRL+P to get the Print menu.
  • Next, from the Print option >> go to the Settings drop-down menu >> then select Print Active Sheets >> and finally, click on Print.

Printing Active Sheets in Excel


2.2. Use ActiveSheet Property in VBA Code to Print Only the Active Sheets

By using Excel VBA Macros, we can print the active sheets from our workbook. To do this, follow the steps below.

  • Go to the Developer tab >> click on Visual Basic >> then insert a new Module >> write down the code there.

Use ActiveSheet Property in VBA Code to Print Only the Active Sheets

VBA Code:

Sub Print_ActiveSheets()
    ActiveSheet.PrintOut
End Sub
  • Next, run the code by pressing the F5 key. This will print all the active sheets on the spreadsheet.

2.3. Using SelectedSheets Property to Print Selected Excel Sheets

You can use the SelectedSheets property to print selected/ grouped sheets from the workbook.

  • Click the Developer tab >> Visual Basic >> from the drop-down menu under Insert >> go to Module >> write the following VBA code.

Using SelectedSheets Property to Print Selected Excel Sheets

VBA Code:

Sub Print_SelectedSheets()
    ActiveWindow.SelectedSheets.PrintOut
End Sub
  • Run the code by pressing F5 >> get the printed copies of selected sheets.

Read More: How to Print Excel Sheet in A4 Size


3. Print Multiple Sheets with a Specific Print Area

Suppose we have multiple sheets of a spreadsheet, but we want to print a specific area from each workbook. We can also do that. So, see the following ways for printing Excel Spreadsheet on multiple pages with a specific print area.


3.1. Manually Adjusting the Print Area for Different Sheets

  • Go to the first worksheet >> select the particular area for printing >> go to the Page Layout tab >> click on the Print Area drop-down menu under the Page Setup group >> then click on the Set Print Area.

Manually Adjusting the Print Area for Apparel-1 Sheet

  • Similarly, go to other sheets and select the print area >> from Page Layout >> go to Print Area >> then press Set Print Area.

Manually Adjusting the Print Area for Grocery Sheet

  • Now, press CTRL+P to get the Print menu >> go to the Settings drop-down menu >> then select Print Entire Workbook >> and finally, click on Print.

Print Entire Workbook with Selected Area


3.2. Using Print Selection to Print Same Area of Multiple Sheets

If you want to print all sheets with a common area, then you can do that too.

  • Hold down the CTRL key >> then select all the sheet names >> after activating all sheets, select the print area.

Print Same Area for Multiple Sheets in Excel

  • Now, press CTRL+P to get the Print menu >> from the Print option >> go to the Settings drop-down menu >> then select Print Selection >> lastly click on Print.

Using Print Selection to Print Same Area of Multiple Sheets

And that’s it! This will only give the printout for the selected specific area.

Read More: How to Print Excel Sheet in Full Page


4. Use Camera Icon to Print Multiple Excel Sheets on One Page

You can print all the required parts from each sheet on one single page. See the following method to print the necessary portion of an Excel workbook on one page.

Here, we will use a built-in but uncommon feature of Excel to do so. Actually, this Camera icon will exactly copy the portion where you hold it. So, we’re going to copy-paste all the required parts into a single sheet and will print that. Firstly, you have to activate that feature.

  • Right-Click on the top ribbon to get the Context Menu Bar >> go to Customize the Ribbon.

Customizing the top ribbon

  • Now, from Choose commands from: >> select Camera >> choose New Tab >> press Add button >> lastly, click on OK.

Adding Camera Icon to the New Tab

As a result, you will be able to see the Camera feature under New Tab in the top ribbon.

  • Now, go to a sheet >> select the area that you want to print >> from the New Tab >> click Camera.

Using Camera Icon in Excel

  • Choose a specific sheet where you will bring all the required portions from other sheets >> go to that sheet >> release the Mouse Cursor there.

Copy Data with Camera Feature in Excel

  • Similarly, we have saved all the information in one sheet.
  • Now, from Page Layout >> go to Print Area >> select Set Print Area.

Setting Print Area

  • Then press CTRL+P to go to the Print menu >> from Print Settings >> select Print Selection >> you may choose Landscape Orientation >> press Print.

Finally, you will get all the important parts on one single page.

Print Multiple Excel Sheets on One Page

Read More: How to Print Sheet on One Page in Excel


5. Using VBA Code to Print Multiple Sheets with Comments in Excel

We can print multiple sheets with comments using VBA Macros. Say there is a comment in a sheet. Now, we will print this sheet with the comment.

Excel Sheets having comment

  • First, from the Developer tab >> click on Visual Basic to open the Visual Basic Editor.
  • Next, go to Insert >> select Module from the drop-down menu >> copy and paste the VBA code.

VBA Code to Print Multiple Sheets with Comments

VBA Code:

Sub Print_with_Comnts()
    Application.DisplayCommentIndicator = xlCommentAndIndicator
    With ActiveSheet
        .PageSetup.PrintComments = xlPrintSheetEnd
        .PrintOut
    End With
End Sub
  • After running the code, you will find this comment at the end of the sheet. Here, the active sheet will be printed. So, make sure that the cursor is on the sheet where you have comments.

Below, you can see the printed copy.

Printed Copy

Read More: How to Make Excel Spreadsheet Bigger When Printing


6. Print Multiple Hidden Worksheets

Sometimes, our sheets could be hidden, and we are not able to print those files, but with Excel VBA this is easy to do.

For your better understanding, we hide the four sheets except one.

Some Excel Sheets are Hidden

  • To begin, click the Developer >> open the Visual Basic Editor by clicking on Visual Basic.
  • Next, select Module from the drop-down menu under Insert.

The Visual Basic Editor will launch as a result of this.

  • Copy and paste the VBA code below to see the final output.

VBA Code to Print All Sheets Including Hidden Ones

VBA Code:

Sub Print_Hidden_sheets()
    Dim Vis As Long
    Dim sheets As Worksheet
    For Each sheets In ActiveWorkbook.Worksheets
        With sheets
            Vis = .Visible
            .Visible = xlSheetVisible
            .PrintOut
            .Visible = Vis
        End With
    Next sheets
End Sub
  • After running the code, you will get all sheets printed, including the hidden ones.

All printed sheets including the hidden ones


How to Print an Excel Sheet with Row and Column Index

You can print a sheet by keeping visible the row and column index numbers.

  • To do so, from Page Layout >> click on the Drop-Down Arrow.

Using Page Setup Option

So, you will get the dialog box named Page Setup.

  • Go to the Sheet menu >> from options in the Print section >> check Rows and columns headings >> press OK.

Print an Excel Sheet with Row and Column Index

Now, if you print this sheet, you will get the row and column index in that printed sheet.

How to Print an Excel Sheet with Row and Column Numbers


Frequently Asked Questions

1. How to print an Excel sheet in A4 size full page?

From Page Layout >> go to the Drop-Down Arrow beside Page Setup group >> in the Paper Size box >> select A4 >> press OK.

After that, print your sheet and get the printed copy on the A4 page.

2. How to print an Excel sheet on a full page?

From Page Layout >> go to the Drop-Down Arrow beside the Page Setup group >> from Scaling section >> check Fit to box >> write 1 in page wide by >> 1 in tall >> press OK.


Download Practice Workbook

You can download the workbook and practice with them.


Conclusion

The above methods assist you in how to print multiple sheets in Excel. Hope this will help you! If you have any questions, suggestions, or feedback, please let us know in the comment section.


<< Go Back to Print Excel Sheet | Print in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Sabrina Ayon
Sabrina Ayon

Sabrina Ayon, a Computer Science and Engineering graduate from United International University, has been an integral part of the ExcelDemy project for two years. She authored 150+ articles, excelling in instructing through visually engaging Excel tutorials. With a passion for teaching, Sabrina conducted sessions on Excel VBA, sharing her knowledge and insights with others. Currently holding the position of Project Manager for the ExcelDemy Visual Development Project, she oversees various aspects of the project, ensuring its smooth operation... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo