|
Is it possible, after selecting trace precedents on a cell, to select or highlight all the cells at once that has an influence on the active cell and being able to move through the workbook and see all highlighted. I am working on a summary sheet and has totalled all the cells of the various sheets onto this sheet, but have missed one or two along the line and it is extremely time consuming to follow each reference individually. Anyone with some advice? |
||||
|
|
|
Check out Aaron Blood's Formula Auditing Tool Explode
A: To install the add-in, all you need to do is put the "EXPLODE.XLA" file in the directory of your choice and then run Excel. From the Excel menu toolbar select "Tools" and then select "Add-ins". If you do not see "Explode" listed in the add-ins window you'll have to use the "Browse" button to find it. Once you've added a checkmark next to the "Explode" add-in you're all set!
Once you do that right click your formula, select explode.. select the cell color tool select the data items and hit color You can do this for each set of data on each sheet and format the cells. Hope this helps! |
||||
|
|
