Forum Discussion
Batch printing of excel sheets
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?
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.