How To Print Excel With Multiple Sheets. To print a portion of the worksheet, do the following: When you select multiple sheets, these all act as active sheets while printing.
But for any printer, you have to select two sheets per page, and click ok. I selected all the sheets and made them have. Open the specified workbook, and then select multiple sheet tabs you will print.