

Note: All of the workbook files that you want to print must be in the same folder.įor adjacent files, hold down SHIFT and select the name of each workbook that you want to print. Hold down CONTROL and click a sheet tab, and then click Select All Sheets on the shortcut menu. Then, hold down COMMAND and click the tabs of the other sheets that you want to select. Then, hold down SHIFT and click the tab for the last sheet that you want to select.Ĭlick the tab for the first sheet. Select the sheets that you want to print.Ĭlick the tab for the first sheet. In the Print drop-down menu, select the option that corresponds to what you want to print ( Selection, Active Sheets, or Entire Workbook) and then select Print. To change what is printed, select Show Details. The default is to print all active sheets. On the Printer menu, select the printer that you want. To print a workbook, click any of its sheets. To print the entire sheet, click the sheet or the sheet tab. To print a partial sheet, click the sheet, and then select the range of data that you want to print.
