If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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??? -- cheers, calvin |
#2
|
|||
|
|||
Problem printing all worksheets in colour
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 On Tue, 22 Dec 2009 10:10:33 +1000, Calvin wrote: 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??? |
Thread Tools | |
Display Modes | |
|
|