Find Unused Input Cells

Find unused input cells

Good spreadsheet practice suggests that if you include a cell as an input cell, it should be used somewhere in the spreadsheet. So if you have a cell with an interest rate of say 9%, it would be very suspicious if no other cell makes use of the input.

Either this input has been ignored (in which case why is it still there) or some other cell is actually used to drive these numbers.

Worse would be if the number is hardcoded into the formula cells i.e. you have cell with 9% but instead of looking at it, all the dependant cells have their own 9% hardcoded into themselves.

Note: if you have stumbled onto this page it would be best if you started at the beginning

Below a video clip explaining what this test in Spreadsheet Professional means

 

Purchase Spreadsheet Professional

 

Back to: Auditing an Excel spreadsheet > Prioritise which formula to look in for errors