ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Blocking out cells when printing (https://www.excelbanter.com/excel-discussion-misc-queries/255464-blocking-out-cells-when-printing.html)

Steve

Blocking out cells when printing
 
I do alot of quotes and I want my customer to be able to see the price on the
Doc. but when it prints can I block out the price to where it comes out black
or not there.
Can this be done. Thank you

trip_to_tokyo[_3_]

Blocking out cells when printing
 
If your Workbook is black text on white background, for the cells you do not
want your customer to see, just make them white text on white background.

Please hit yes if my comments have helped.

Thanks.

"Steve" wrote:

I do alot of quotes and I want my customer to be able to see the price on the
Doc. but when it prints can I block out the price to where it comes out black
or not there.
Can this be done. Thank you


Jim Thomlinson

Blocking out cells when printing
 
Certain colour combinations appear as black when printed on a black and white
printer. You might have to play around with the combinations to make it work.

Navy Blue background with Dark Red text may work for you.
--
HTH...

Jim Thomlinson


"Steve" wrote:

I do alot of quotes and I want my customer to be able to see the price on the
Doc. but when it prints can I block out the price to where it comes out black
or not there.
Can this be done. Thank you



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

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