Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change multiple worksheets at one time to print in color
For some reason I have to go through and change each worksheet individually
to print in color. Then I can select all of the worksheets to print and it prints correctly. The next time I open the document, it hasn't saved my change to print all worksheets in color. And it didn't used to be like that; I've just noticed the problem in the last few months - and I haven't upgraded or anything. 1) There has to be a way to select all of the worksheets at once and tell the software to print all sheets in color. 2) Then, I would like to make sure it keeps that change to print all sheets in color. When I search the Excel help within the software all I can find is how to print in black and white and not one help on printing the sheet in color. I think that's really strange. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change multiple worksheets at one time to print in color
Right-click on a sheet tab and "Select all sheets"
On active sheet go into print settings and uncheck black and white and draft quality. All sheets will be set to print in color. Select one sheet tab to ungroup the sheets. NOTE: all sheets will receive most print settings from the active sheet. Print Range and rows to repeat at top will not be carried to all sheets. Print settings should be saved when the wokbook is saved. If this is not happening for you, you have some other problem not related to print settings. Gord Dibben MS Excel MVP On Tue, 5 Jan 2010 12:51:01 -0800, Sundance wrote: For some reason I have to go through and change each worksheet individually to print in color. Then I can select all of the worksheets to print and it prints correctly. The next time I open the document, it hasn't saved my change to print all worksheets in color. And it didn't used to be like that; I've just noticed the problem in the last few months - and I haven't upgraded or anything. 1) There has to be a way to select all of the worksheets at once and tell the software to print all sheets in color. 2) Then, I would like to make sure it keeps that change to print all sheets in color. When I search the Excel help within the software all I can find is how to print in black and white and not one help on printing the sheet in color. I think that's really strange. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Multiple worksheets | Excel Worksheet Functions | |||
Print multiple excel sheets in color | Setting up and Configuration of Excel | |||
Globally change print settings for several worksheets at the same | Excel Discussion (Misc queries) | |||
how can I get all worksheets to print at one time? | Excel Worksheet Functions | |||
is it possible to change print ink color based on cell value? | Excel Discussion (Misc queries) |