Looking up where a cell is referenced

I am editing an old excel file and I don't remember everything about it. Is there a way in excel 2007 to click on a cell and find all the places it is referenced within the workbook?
For example if I use cell A2 in a formula in cells K3, K4, and K44. I am looking to be able to click on A2 and a search will so me I am using that cell in cells K3, K4, and K44 as a reference.

Thanks,

Originally Posted by DonkeyOte

see the Trace Dependents button on the Formula Tab in the Ribbon

Thanks! I did this and I have a ton of references. I really just want to move cells to another location, can I do this and still have the numbers referenced in other locations? When I copy and paste it goes to REF.

For example, if I have a cell in A1 and it is referenced in A2. But if I want to copy A1 over to B1, it will reference B2. How do I copy and Paste to B1 and the information will still be correct in A2????
I know the example is a simple fix, but in my real spreadsheet I have MULTIPLE references.

Thanks,

Originally Posted by NBVC

If you copy the formula from A1 and then select B1 and paste the formula in the formula bar or double-click B1 (or hit F2, while in B1) and when you see a cursor paste the formula, it will then still reference A2....

Yes, but the problem I have is I multiple references that use A1. It is easy on a small scale, but I have about 50 cells scattered through out my spreadsheet that use A1 as a reference, so when I move A1 I lose the info.

Originally Posted by NBVC

Can you make those references absolute (i.e add a $ before the A)

You might be able to do it through Edit|Replace and Replace A1 with $A1 or $A$1 depending on if you want to keep the row reference too.

No, if I put $A1 or $A$1 and I want to move A1 to B1 all of my cells that use A1 as a reference will be looking for A1, not B1. I think I am just SOL and need to go manually through every cell can change it?

Originally Posted by ChemistB

If you cut A1 and move it rather than copy and move it, I think all your references will move with it.

WOW, thanks. Making something easy so hard. I appreciate the help. The cut and paste worked great