using colours

S

Steven

hi peeps, just wondering how to use fill colour in cells but for the colours
not to be printed?

Thanks,
Steve-
 
G

Gord Dibben

Steve

File>Page Setup>Sheet. Checkmark in "Black and White" and/or "Draft Quality"

Gord Dibben Excel MVP
 
S

Steven

cheers Gord,

oh, what about using colours for formulas? anyway to auto colour cells to
show linking cells?

Many Thanks,
Steve
 
D

Dave Peterson

How about an ugly way?

When you are editting the formula (and can see the precedents), hit
alt-printscreen.

Then paste into your favorite graphics program.

You could also show the audit (or formula auditing) toolbar. Click on the show
precedents and print while the arrows are shown.
 
Top