ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Set sheet to "Not Print Fill Color" (https://www.excelbanter.com/excel-discussion-misc-queries/135179-set-sheet-not-print-fill-color.html)

Ben Dummar

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

Teethless mama

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



All times are GMT +1. The time now is 02:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com