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.
Step 3: Click the Print option in the column at the left side of the window.
Step 4: Click the Print Active Sheets drop-down menu at the center of the window, then choose the Print Entire Workbook option.
Step 5: Click the Print button at the top of the window to print your workbook.
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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.