ChatterBank4 mins ago
Excel 2016 Printing
3 Answers
Can someone explain how I can print non-adjacent sheets of a workbook please? On previous releases you simply entered 1,3,7 etc. but now it seems you can only enter first & last and so everything in between prints.
The old system is still possible in Word 2016.
The old system is still possible in Word 2016.
Answers
1 to 3 of 3
Best Answer
No best answer has yet been selected by woofas. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
Select the sheets that you want to print by navigating to one of them, then keeping the CTRL key pressed and select (click on the "Sheet Tab") of the other sheets you want to print. This effectively makes multiple sheets "Active" rather than just one sheet that is usually active.
You can see the ones selected you have as they will be highlighted. You can deselect sheets if required by on them clicking again.
Then print "Active Sheets" - this is actually the default print setting.
This will print only the sheets you selected.
You can see the ones selected you have as they will be highlighted. You can deselect sheets if required by on them clicking again.
Then print "Active Sheets" - this is actually the default print setting.
This will print only the sheets you selected.
It would appear that this is not possible as the controls that Word has for doing this are not available in Excel.
This has a couple of solutions, neither of which is particularly straightforward but will do what you need: http://
This has a couple of solutions, neither of which is particularly straightforward but will do what you need: http://
1 to 3 of 3
