|
Is it possible to select a cell with references and have all of those references be I am working on a summary sheet and it has totaled all the cells of the various sheets onto one sheet, but I have missed one or two along the line and it is extremely time consuming to follow each reference individually. Anyone with some advice? | ||||
|
feedback
|
|
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! | ||||
|
feedback
|
