1. Home
  2. MS Office

Excel 2010: How To Print Complete Workbook (With All Worksheets)

Excel 2010 offers printing of Excel worksheets in multiple ways. You must be familiar with printing of active sheet and custom selection of print area. In this post we will look at how to print complete Excel workbook including all the spreadsheets.

To print the whole workbook (with all worksheets), on File menu, click Print. Form main window, select Printer and select Print Entire Workbook. Once done, click Print button.


Options at each side will let you print active sheets and select print area respectively.


  1. these instructions are obvious. But i seems to have to change the page set-up, margins, and printer options (1 side or 2 side) separately for each sheet — in which case there’s little point in having a “print entire workbook” command. In case that’s not clear, i find these instructions USELESS

    • Each page has different page set-ups, but when I choose to print workbook the pages all print with the first page’s set-up

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.