Show all Precedents at once

[Jeffrey Green]

I get a spreadsheet from people that can't seem to get it right.

I have a couple thousand rows, and about 5-6 hundreds uniques Entries.

between each entry, there is a couple of rows, one we use for AutoSum.

I need to Trace Precedents on columns d,e,f . . . . and M and N . .


is there any way to have excel show me ALL my precedents at once???


Thanks

 

[Jeffrey Green]

FOUND IT!

> Select any empty cell
> Type "="
> Click on the upleft corner of your worksheet to select all the cells.
> Usually next to "=" will be written 1:65536
> Then press ENTER.
> Excel will complain ciclular reference.
> Click on OK.
> Select the cell were is written the above. (in the cell with the new formula)
> Double click on the button "Trace Precedents"
> Ups!!! Here are all the arrows!!

Credit to Birmangirl on ExcelBanter.com

pretty slick

 

[brettdj]

Thanks for the followup - that is a cool trick that will certainly come in useful

Works fine in xl2010.