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.


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.

Downloadable Files: Excel File

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Display all Formulas at Once in Excel
Tutorial: How to view all of the formulas at once in Excel so that you can troubleshoot the spreadsh...
View Different Parts of a Worksheet at Once in Excel
Tutorial: View different sections of the same worksheet when the sections are far apart.  This all...
Protect and Unprotect All Worksheets at Once
Macro: This will allow you to protect or unprotct all worksheets in a workbook at once. It doesn'...
Filter Data Sets on Multiple Columns with Multiple Criteria at Once in Excel - AutoFilter
Macro: This Excel macro allows you to filter a data set on multiple columns and criteria at once....
Quickly Resize Multiple Columns or Rows at Once in Excel
Tutorial: How to quickly resize multiple columns and rows at once in Excel.  This avoids having to...
3D References - Formulas that Reference Multiple Sheets at Once in Excel
Tutorial: Have one simple formula that will reference the same cell or range of cells on multiple w...