How to Print an Entire Excel 2010 Workbook

The default print action for an Excel 2010 file is to print the entire worksheet that is currently open.

If you have read any of our other articles on printing in Excel 2010, such as this one about fitting an entire worksheet on one page, then you know how much you can customize a print job in Excel to suit your current needs.

This extends even further, as you can also choose to print an entire Excel workbook, as opposed to only the currently active sheet.

If you have ever had to print an entire workbook before, then you know how tedious it can be to keep alternating between worksheet tabs and the Print menu.

By learning how to print an entire Excel 2010 workbook you will save yourself a lot of time.

Printing All Excel 2010 Workbook Worksheets at Once

The Excel file format, with its ability to store multiple worksheets within one workbook, is a lifesaver for people that are working with large amounts of data.

It keeps everything organized in one location, preventing you from having to navigate between multiple files.

Additionally, you can reference data in other worksheets as parts of formulas. Now that you will know how to print all of the worksheets in an Excel workbook at once, you will have one more reason to embrace the multiple worksheet format.

Step 1: Begin by opening your Excel workbook.

Step 2: Click the File tab at the top-left corner of the window.

click the excel 2010 file tab

Step 3: Click the Print option in the column at the left side of the window.

open the excel 2010 print menu

Step 4: Click the Print Active Sheets drop-down menu at the center of the window, then choose the Print Entire Workbook option.

how to print an entire excel 2010 workbook

Step 5: Click the Print button at the top of the window to print your workbook.

Now that you know how to print an entire workbook in Excel 2010, you can use this option to make large print jobs much easier on yourself.

Note that this setting does not get saved. If you save your workbook, close it, then re-open it, Excel will default back to only printing the active worksheet. You will need to redo the steps in this tutorial if you want to print the entire workbook again.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Leave a Comment