EXCEL Cell Xref is it possible? 1

[BJZeak]

Excel provides a graphical picture of other cells referenced by a formula in a selected Cell ... however is the reverse true? IE is there some way to ask Excel for a list of cells that reference a selected cell?

I have a multisheet workbook that I created several years ago and it is now tedious to look back at all the references for any given cells to ensure new variations aren't missing a key input.

 

[SkipVought]

Check out Trace Precedents & Trace Dependencies.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PeterMoran]

Hi,

You may find this url useful:

http://excelribbon.tips.net/Pages/T006233_Creating_a_List_of_Worksheet_Formulas.html

It shows how to create a word document with all the formulas.

Good Luck!

Peter Moran