Cell Dependencies

G

Guest

Is there anything similar to the 'Object Dependencies' function in Access for
cells/forumlae in Excel? I've taken over a spreadsheet that needs a massive
overhaul and want to see which cells reference a cell that I may alter?

Ta
 
G

Guest

Move to a cell with a formula and the click TOOLS, FORMULA AUDITING and
select TRACE DEPENDENTS. Repeat the process and select TRACE PRECEDENTS
 
G

Guest

You can also select a multiple cells and press F5 and then click the SPECIAL
command button and select PRECEDENTS or DEPENDENTS. This will highlight the
cells instead of showing auditing arrows
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I protect data in a cell, but allow comments to be entered. 6
Formula shows in cell instead of results (text reference) 4
referencing a cell in another worksheet 5
Setting up Treasure Hunt spreadsheet 11
stumped on creating dependent data validation lists 1
Making a spreadsheet calculate faster 4
vlookup maybe 3
Can I insert a picture depending on the contents of another cell? 1

Top