Print All Worksheets at Once in Excel

Add to Favorites

How to print all worksheets at once from Excel.

This saves you the time of having to go to each sheet individually to print.

  1. Hit Ctrl + P to get to the print screen.
  2. Click where it says Print Active Sheets and select the option Print Entire Workbook.
  3. 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.

Like this tutorial? Follow us on Google +

Excel Version: Excel 2007, Excel 2010, Excel 2013
Downloadable Files: Excel File