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
|
|||
|
|||
Display -vs- Print Format in Cells
Is is possible to apply different display and print
formating criteria to a cell, range of cells or an entire worksheet? For example, when viewing cells, I like to use a full range of colors, but colors don't always print well on a b&w printer. I would like to print WITHOUT colors. I can always manually disable the colors in cells right before printing, but having to do that is annoying. Thanks! |
#2
|
|||
|
|||
Display -vs- Print Format in Cells
Most printers have a "Monochrome" or "Black and White" option somewhere in
their setup menus.......might this do it for you? Or, you could always mirror your sheet to another sheet and remove all color from that one and then use it to print out your hard copies. I've done this before and it worked quite well, set up with recorded macros to print either the color or the black and white version.....of course this limits Conditional Formatting, if you're using it.......... Vaya con Dios, Chuck, CABGx3 "Willie" wrote in message ... Is is possible to apply different display and print formating criteria to a cell, range of cells or an entire worksheet? For example, when viewing cells, I like to use a full range of colors, but colors don't always print well on a b&w printer. I would like to print WITHOUT colors. I can always manually disable the colors in cells right before printing, but having to do that is annoying. Thanks! |
#3
|
|||
|
|||
Display -vs- Print Format in Cells
Willie
FilePage SetupSheet. Check in "black and white" should work for you. Maybe also check "draft quality"(shot-gunning here). Gord Dibben Excel MVP On Tue, 8 Jun 2004 10:47:26 -0700, "Willie" wrote: Is is possible to apply different display and print formating criteria to a cell, range of cells or an entire worksheet? For example, when viewing cells, I like to use a full range of colors, but colors don't always print well on a b&w printer. I would like to print WITHOUT colors. I can always manually disable the colors in cells right before printing, but having to do that is annoying. Thanks! |
Thread Tools | |
Display Modes | |
|
|