excel assistance asap please

[Mattlan]

Need to show on printed record the cells that have been used to =C5+C6+C13 etc

how does one highlight these, tried precedent in formula'a but does not seem to stay once you move to another column?

Any help gratefully received!!

[Mattygooner]

Ask the paper clip..or einstein..

[AndyAudi]

There is an option "Show Formulas"

This displays all your cell's with the formulas used (But doesn't show the result)

It's on the formula tab in 2007 but I think it is in Tools Sheet Options in previous.
Downside it applies to whole sheet?

Edited by AndyAudi on Wednesday 18th March 13:54

[merc_man]

Not sure I really understand.

Do you want to

a) Highlight the cells that are used in a calculation
b) Have a cell showing the formula used in a calculation

[Mattlan]

want to highlight the cell values used in calculating a "=C12+C17+C22" value

[aclivity]

Have you tried the "formula auditing" toolbar? There is a "trace precedents" button on there.

[Samcat]

I put this into the help search box, I think it might help - "Display the relationships between formulas and cells"

[CVP]

aclivity said:

Have you tried the "formula auditing" toolbar? There is a "trace precedents" button on there.

This is the one, draws a line fromt he cell that has the formula in it to the cells used in the formula (assuming they are on the same tab) and puts a round dot by the cells actually used.

Chris

[RupertTheFridge]

If you want to just see the cells being used in a calculation, simply select the cell that has the result, then click in the formula bar and it will highlight the cells colur coded to show them relevant to the calculation.

[fish]

If you want to then print what you see on the screen for an example the use screen print.

[Jinx]

Press ctrl and the button above the tab (the " ¬ ` ¦ " button) - job done.