RE: Formula
Hi Renu,
There is a formula auditing toolbar, which shows where the values in your formula orginate from and which cells are affected by them. (Trace Dependants, Trace Precedence). There is also a Watch window where you can view the contents, formula and value of one cell by scrolling through others.
I hope that answers your question, if there was anything more specific please let me know.
Tracy