How to Print Multiple Sheets in Excel: 6 Suitable Examples

Method 1 – Print All Sheets at Once in Excel

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

Use the Print Entire Workbook feature for printing all sheets at once.

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

Opening File tab

  • From the Print option >> go to the Settings drop-down menu >> select Print Entire Workbook >> just click on the Print button.

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

How to Print Multiple Sheets in Excel


1.2. Use of VBA Code to Print the Entire Workbook

Use VBA Macros to print the entire workbook at once. We need to follow the procedure down.

  • 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

  • Go to Insert and select Module from the drop-down menu.

Inserting Module

  • 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

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

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.
  • 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
  • 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. We named our new PDF file “PrintAllSheet”.
  • 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.

1.4. Print Some Certain Sheets by Using VBA Code

Print multiple sheets using the VBA Macros. We are going to print some defined sheets with a VBA code.

  • In the previous method, to open the Visual Basic Editor, go to the Developer tab on the ribbon >> click on Visual Basic >> from Insert >> select Module >> 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

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.


Method 2 – Print Multiple Active Sheets

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

Talk about how you can print these activated sheets at once.


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

  • Press CTRL+P to get the Print menu.
  • From the Print option >> go to the Settings drop-down menu >> select Print Active Sheets >> and finally, click 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
  • 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

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.

Method 3 – Print Multiple Sheets 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 >> click on the Set Print Area.

Manually Adjusting the Print Area for Apparel-1 Sheet

  • 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

  • Press CTRL+P to get the Print menu >> go to the Settings drop-down menu >> then select Print Entire Workbook >> and, 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 >> select all the sheet names >> after activating all sheets, select the print area.

Print Same Area for Multiple Sheets in Excel

  • Press CTRL+P to get the Print menu >> from the Print option >> go to the Settings drop-down menu >> select Print Selection >> click on Print.

Using Print Selection to Print Same Area of Multiple Sheets

This will only give the printout for the selected specific area.


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

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

Customizing the top ribbon

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

Adding Camera Icon to the New Tab

You will be able to see the Camera feature under New Tab in the top ribbon.

  • 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

  • We have saved all the information in one sheet.
  • From Page Layout >> go to Print Area >> select Set Print Area.

Setting Print Area

  • 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


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

Print multiple sheets with comments using VBA Macros. Print this sheet with the comment.

Excel Sheets having comment

  • From the Developer tab >> click Visual Basic to open the Visual Basic Editor.
  • 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. The active sheet will be printed. Make sure that the cursor is on the sheet where you have comments.

See the printed copy.

Printed Copy


Method 6 – Print Multiple Hidden Worksheets

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

  • Click the Developer >> open the Visual Basic Editor by clicking on Visual Basic.
  • 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.

  • From Page Layout >> click on the Drop-Down Arrow.

Using Page Setup Option

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

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.


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

Get FREE Advanced Excel Exercises with Solutions!
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