excel links

B

BINZA@

I have been given an excel file with many formulas and links and possibly
macros. I am wondering if its possible to see all of these displayed so I
can see simply what's going on where its looking for data.

Thanks for any help.
 
M

MartinW

Hi Mark,

You can go to Tools>Options>View Tab and check Formulas
under Window options. This will display all the formulas in the sheet.
You can also click on a cell that contains a formula and go to
Tools>Auditing>Trace Precedents. This will put arrows to the last
cell referenced by a formula, then click on that cell and Trace precedents
again etc. etc. until you reach the source. You can also do the same
with Trace Dependants.

HTH
Martin
 
E

Earl Kiosterud

Binza,

There's a shortcut to take it in and out of the formula-display mode Martin told of. Press
Ctrl` (that's the key left of the 1 key, with the ~ in the upper case position). It would
have been useful had they put that shortcut in that Tools dialog, and I think they plan to
do that in 2057.
 
Top