If you want to print all sheets, from the print menu, simply choose. Microsoft Print to PDF Print Entire Workbook If you want an arbitrary subset of sheets, use CTRL+Click on the sheets that you want. Each selected tab will highlight like Sheet8 and Sheet10 in the following example. Now in the print menu, select “Print Active Sheets” instead of “Print Entire Workbook”