Select first sheet then right-click on tab and "Select all sheets".

Do your print setup on the one sheet and it will be done on all.

Unavailable options with grouped sheets will be setting print range and rows
to repeat at top.

All color options should be available.

DO NOT FORGET to ungroup the sheets when done.


Gord Dibben Excel MVP

On Thu, 17 Feb 2005 15:27:05 -0800, "Aussie CPA" <Aussie
wrote:

Hi there,
I have a spreadsheet with multiple sheets containing colour formatting
(including graphs) that is regularly printed out in colour and greyscale. The
problem I have is that when I need to print out several sheets simultaneously
I uncheck the "Greyscale" option under print options and have the print job
come out in colour. To print multiple selected sheets in colour I need to
change the print options for each individual sheet (about 10 in all) to
colour (non- greyscale). One strange peculiarity of this is that some of the
sheets will not need to be "Unchecked" whereas others will. They are not
necessarily the same sheets each time either.
Unfortunately due to page numbering I cannot print out each sheet one by one
either.
I have the reverse problem when I want to print in Draft in Greyscale.

Can someone help me? Is the colour status controlled by the sheet, the
workbook, or the printer? Can anyone suggest a solution?


Thanks for you help,