Cannot print all sheets

Copper Contributor

I have Excel 2019, and I am trying to print some of the sheets from my workbook, but whether I print the whole book, or just the particular sheets, I am unable to print anything other than my first sheet.  I have none protected, and I have my options under the print workbook option.  HELP!

2 Replies
Do you have a print area set on each sheet you want to print?

If you Ctrl Click each sheet to select them before printing does that work?

@ShaneShane To print all worksheets from the book, at the worksheet tab press shift then click the first tab and the last tab. It will select all worksheets in between and go to print.

 

Make sure all printing setups are done already prior to this step (printing area etc.)

 

If only a few worksheets out of many, use ctrl click.

 

Please see if this helps and please accept as solution if it helped. Thanks!