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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplex printing 7
Printing problem 5
Protect a sheet from Printing within a workbook? 7
A Macro to Print sheets in mult w.books 2
How to record a macro within a macro 9
Printing options for all sheets in a workbook? 3
Excel print area which only prints pages of worksheet which are active 0
Excel Macro to un-mute Audio/speakers. 15

Back
Top