Print active sheets(s)

  • Thread starter Thread starter Wapiti
  • Start date Start date
W

Wapiti

In the Excel print dialog, there is an option to print "Active Sheet(s)"

How can you have more than one active sheet??

If its possible, it will help my need. I need to be able to print all
sheets except the first sheet in the workbook. How can this be done?

Thanks!

Mike
 
If the sheet tabs you want to print are adjacent (right next to eachother),
then click the first in the group (in your example your 2nd sheet tab). Hold
down Shift and click the last sheet tab in your group.
If they are non-adjacent, click the first then hold down Ctrl and click the
next. Keep Ctrl-clicking the other sheet tabs.
 
Back
Top