trace precedents for all cells

[ammartino44]

Hello. I'm analyzing an income statement where I bucket all of the line items at the bottom in different categories. However, when I sum all the categories it doesn't sum up correctly. That means that I'm missing a few line items but it is an enormous pain to figure out which ones are missing. Is there any way to figure this out quickly?

Thanks,

[FDibbins]

If you press F2 on the formula, it will show you (with colored lines around the cells) which cells are being used. You can scroll up/across while in Edit mode to see if you have missed anything

[FDibbins]

You can also click on the cell, then select Formula Tab.Formula Auditing/trace dependants