S Steven Apr 14, 2004 #1 hi peeps, just wondering how to use fill colour in cells but for the colours not to be printed? Thanks, Steve-
hi peeps, just wondering how to use fill colour in cells but for the colours not to be printed? Thanks, Steve-
G Gord Dibben Apr 14, 2004 #2 Steve File>Page Setup>Sheet. Checkmark in "Black and White" and/or "Draft Quality" Gord Dibben Excel MVP
Steve File>Page Setup>Sheet. Checkmark in "Black and White" and/or "Draft Quality" Gord Dibben Excel MVP
S Steven Apr 14, 2004 #3 cheers Gord, oh, what about using colours for formulas? anyway to auto colour cells to show linking cells? Many Thanks, Steve
cheers Gord, oh, what about using colours for formulas? anyway to auto colour cells to show linking cells? Many Thanks, Steve
D Dave Peterson Apr 15, 2004 #4 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.
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.
