PRINTING WORKSHEETS 1

[jatolo]

Hi guys
Once again....

I have 10 worksheets in one workbook, How can I select which worksheets I need to print???? o how can I print all of them at once??
Thanks for your support........

 

[PGoRule]

When you look at the Print Dialog...There is one section 'Print what'.
Under that section, you have choices to print Entire Workbook, the selected part from your sheet, or the active sheets. Each active sheet or the sheets present in your workbook are printed on seperate pages.

Sharing the best from my side...

--Prashant--

 

[jatolo]

Thanks Pgorule, I need to clean up my glasses....

 

[firefytr]

Also, if you don't want to print all sheets, but more than one with a single swift click, press and hold either the Shift (selects everything between) or Ctrl (selects individually) while clicking other sheet tabs. Now certain methods are applied to all sheets (ie printing, entering formulas, etc).

HTH

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[jatolo]

Thanks Firefytr It works great

Jatolo