✦Template Printable Ideas Insights

Print All Excel Sheets Together

By

Printing all sheets in an Excel workbook at once can save you considerable time and effort, especially when dealing with large workbooks consisting of multiple sheets. However, Excel doesn't directly allow this, and you'll need to use a few workarounds. Here's how to print all sheets in Excel together using two common methods: Print Area and VBA (Visual Basic for Applications).

Before we dive into the methods, make sure your workbook has all the sheets you want to print. To add sheets, right-click on the sheet tab, select "Insert", and choose the number of sheets you want to add. You can then rename them by double-clicking on their tab.

Using Print Area to Print Multiple Sheets

The Print Area feature allows you to specify a range of cells to print, encompassing cells from multiple sheets. Here's how to set up a Print Area in Excel:

Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
How to print top row on every page in Excel
How to print top row on every page in Excel
Copy Data From One Sheet to Another in Excel
Copy Data From One Sheet to Another in Excel

1. Activate the first sheet you want to print. Select all the cells you want to print, press Shift + F5, and choose "Set Print Area".

Adding More Sheets to the Print Area

To include more sheets in the Print Area, activate each sheet one by one and select the range of cells you want to print. Then press Shift + F5 and click "Add to Print Area".

Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know
Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know
How to Set the Print Area in Excel (with pictures)
How to Set the Print Area in Excel (with pictures)
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips

2. Once you've added all sheets to the Print Area, go to the "File" menu, click "Print", and choose your preferred print settings. Finally, click "Print All" to print all sheets in the specified Print Area.

Printing in Landscape or Portrait Orientation

If your data extends beyond the width of a page and you need to print it in landscape orientation, right-click on the print preview, select "Print Area", and choose "Full Page SlANT". Then adjust your margins as needed and click "Print All".

Using VBA to Print All Sheets

VBA offers a more automated approach to printing all sheets in an Excel workbook. Here's how to use VBA to accomplish this:

How To Print Large Excel Sheet | One Page Print Setup (Excel Tips & Tricks)
How To Print Large Excel Sheet | One Page Print Setup (Excel Tips & Tricks)
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
how to create a master sheet from multiple sheets in excel
how to create a master sheet from multiple sheets in excel
How to Print Multiple Sheets on One sheet in Excel by learning center In Urdu/Hindi
How to Print Multiple Sheets on One sheet in Excel by learning center In Urdu/Hindi
How to combine worksheets. 🤓
How to combine worksheets. 🤓
the advanced excel chart sheet is shown in green and has instructions on how to use it
the advanced excel chart sheet is shown in green and has instructions on how to use it

1. Press Alt + F11 to open the Visual Basic Editor. Go to "Insert" in the menu and click "Module" to insert a new module.

Entering the VBA Code

In the new module, type or copy-paste the following code:

Sub PrintAllSheets()
    Dim ws As Worksheet

    For Each ws In ThisWorkbook.Worksheets
        ws.PrintOut
    Next ws
End Sub

2. Save the module with a descriptive name, such as "PrintAllSheets". Then, go back to your workbook by clicking the "X" icon or the "Browse" button next to the "Project" dropdown.

[FREE] 141 Free Excel Templates and Spreadsheets
[FREE] 141 Free Excel Templates and Spreadsheets
Excel - Link Data Between Worksheets In A Workbook In Excel
Excel - Link Data Between Worksheets In A Workbook In Excel
how to print large excel sheet in one page
how to print large excel sheet in one page

Running the VBA Macro

To run the macro, press Alt + F8, select "PrintAllSheets" in the list of macros, and click "Run". The VBA code will print all sheets in your workbook, one by one, using the default print settings.

And there you have it! Now you know how to print all sheets in Excel together using both manual and VBA methods. The next time you need to print multiple sheets, you can save time and effort by using these techniques. Happy printing!