| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set sheet to "Not Print Fill Color"
Hi,
We have a spreadsheet that we put a Green fill in the background to let the users know they need to fill out those cells. These sheets are printed and then faxed. How do we set the sheet to print without printing the fill color so that the data is still legible after transmitting through the fax? We have tried it with no fill color and only unlocking the cells that need to be filled so one could tab through it, but for some reason it is not always completed like it is when the background is color coded for them. Thanks, Ben |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Set sheet to "Not Print Fill Color"
File Page Setup Sheet tab under Print select Black and white OK
"Ben Dummar" wrote: Hi, We have a spreadsheet that we put a Green fill in the background to let the users know they need to fill out those cells. These sheets are printed and then faxed. How do we set the sheet to print without printing the fill color so that the data is still legible after transmitting through the fax? We have tried it with no fill color and only unlocking the cells that need to be filled so one could tab through it, but for some reason it is not always completed like it is when the background is color coded for them. Thanks, Ben |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Incorporating Cell color fill in an "if" logical function? | Excel Worksheet Functions | |||
| How do I change the fill color of a cell using an "IF" function | Excel Worksheet Functions | |||
| How can I get my "print preview" to display in color instead of b& | Excel Discussion (Misc queries) | |||
| Can a few long, narrow Excel cols be "wrapped" to fill print pag | Setting up and Configuration of Excel | |||
| How to fill in "BLANK" Cells Automactically...Large Spread Sheet | Excel Discussion (Misc queries) | |||
Linear Mode
