Excel Question

If you double click on a cell with some formula in that relies on other cells it should highlight the other cells involved in that calculation

Cheers Joe, that's backwards to what I need though.

Example off the top of my head

In B2 I'd have the amount of time left in a soccer match

I'd have several other cells that relied on this in their formulae (match odds, over under 2.5, etc) and would like to see which ones they were without clicking on every other cell.

If you use cut, instead of dragging the cell, once you then paste the cell elsewhere it should retain any of the original references

Awesome, I'll test that out. Thanks.

K, I see what your trying to get at , can't think of any simple command to do it. You might have to do some VB code to search the sheet for any reference to that cell reference then highlight or list them

You can do what you wnated just using find Lori.

Control+F just make sure in the options you specify to look in formulas, you could then just step thru all cell using that reference by clicking find next

haha, excellent. Sometimes the obvious isn't obvious.

That will do just fine, thanks again :)

or use the formulas/auditing toolbar and Trace dependents.
(depends on version of excel). auditing toolbar might be an add-in in earlier excel versions

That's also awesome too billy.

Excuse my apparent hyperbole in this thread, I'm genuinely really happy to have got some decent advice and I've run out of different words to use :)

lori had to go for a smoke after this

The trace dependents function thing is actually so amazing I may have to get Danny Morrison to describe it for me. All the methods in this thread helped me a lot , but the trace arrows are the nuts.

maybe coney could write a rap about them :)

Lori not sure if you have realized ~
Trace dependents when clicked once shows arrows to direct dependents
when clicked more than once shows dependents on the dependents
Click till it beeps and will show all dependencies.
Same with precedents.
cheers

Hadn't spotted that either CM, although it's not what I need for this one, I'm going to have good fun with that I can tell :) Cheers.

Lori maybe this is what you want a simple macro. This one does Precedents to do
Dependents substitute Precedents in line 5 to Dependents.
This, when run will put all cells referenced by selected cell in column 10 starting at
row 1 ($J$1)

Sub PrecedentCells()
Dim I As Long
Dim cell As Range
I = 1
Selection.Precedents.Select
For Each cell In Selection
Cells(I, 10) = cell.Address
I = I + 1
Next cell
End Sub

Ok, this would be a good time for me to start using macros. I've never done it before but always known I would need to in the end so I'll look closer on Monday (when the sport dies down a bit) and go through it stage by stage with google.

Thanks again.