Print All Worksheets at Once in Excel
How to print all worksheets at once from Excel.
This saves you the time of having to go to each sheet individually to print.
- Hit Ctrl + P to get to the print screen.
- Click where it says Print Active Sheets and select the option Print Entire Workbook.
- That's it! It's as simple as that.
Notes
There are a lot of different printing options for Excel. It is well worth it to play around with the options on the Page Layout tab to see what can be useful to you. You can also check out our other printing tutorials for Excel.
Download the sample workbook that comes with this tutorial to try this feature out.
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Tutorial: How to view all of the formulas at once in Excel so that you can troubleshoot the spreadsh...
Tutorial: View different sections of the same worksheet when the sections are far apart. This all...
Macro: This will allow you to protect or unprotct all worksheets in a workbook at once. It doesn'...
Macro: This Excel macro allows you to filter a data set on multiple columns and criteria at once....
Tutorial: How to quickly resize multiple columns and rows at once in Excel. This avoids having to...
Tutorial: Have one simple formula that will reference the same cell or range of cells on multiple w...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)