Problem printing all worksheets in colour



Whe I go to print an excel 2007 spreadsheet with multiple worksheets,
select print entire workbook, set the printer to colour, but only the
selected worksheet prints in colour, all others in b&w. How can I get them
all to print in colour???



Gord Dibben

Each worksheet has its own print setup so color print has to be set on each
sheet. Setting the printer to "color" will not override sheet settings.

You can do this by right-click on first sheet and "Select all Sheets"

Go through print setup for activesheet and will be done to all.

When print setup is complete ungroup the sheets.

Now when you print entire workbook, all sheets will print in color.

NOTE: when performing a grouped print setup all sheets get same print
options as the activesheet.

ALL does not include print range and rows to repeat at top.

Gord Dibben MS Excel MVP

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