Using the Formula Auditing tools

Once you've created a spreadsheet or you get one from someone else, one of the more painful things you end up doing at some point is trying to work out which cells feed into any of the formulas throughout the workbook or alternatively, which cells are dependent on any given cell(s).

So how can you check this without spending hours looking at all the cells in your worksheet/workbook? This is where the FORMULA AUDITING tools come in.