Hi Tom
Yes you can set a print area for multiple worksheets:
Right-click on any sheet tab and choose "Select all sheets" (please note
this option may vary since i am using a french version of Excel)
If you do not want to set this for all of your sheets, press <Ctrl and
select each sheet tab you wish to add and release <Ctrl when you are done.
Define your print area, it wil be set for the selected sheets.
HTH
Cordially
Pascal
"tntvk" a écrit dans le message de news:
...
I have a workbook with multiple (50) worksheets. I need to print only a
section for all worksheets. Is there a way I can set a print range for
all
worksheets?
ANy assistance is greatly appreciated
Thank You
Tom