Batch printing of excel sheets

Occasional Contributor

I am printing the excel sheets one by one, but I feel inconvenient.
Is there a way to batch print sheets?
And is there any way to print the excel document as a whole?

1 Reply


If you select File > Print, you'll see a drop-down below the word Settings. You can specify here whether you want to print:

  • Print Selected Sheets. You can select multiple sheets by either clicking the sheet tab of the first sheet you want to print, and Shift+clicking the sheet tab of the last sheet you want to print, or by Ctrl+clicking the sheet tab of each sheet that you want to print.
  • Print Entire Workbook. You don't have to select all sheets for this option.
  • Print Selection. This will print the selected cells only.