The "Go To" Function
We deal with huge data running into thousands of rows and may be hundreds of column. Say for example an auditee gave you a workbook with huge data with lots of formulae. As an auditor you want to check if any cell contains manual input instead of a formula?
Here is how this function helps.
Select the data you want to test/check.
Press "F5" or Ctrl+G, A GoTo dialogue box opens. Select Special - A new dialogue box would open with lots of options.
If you select constant - It would highlight all cells which do not have formulas.
If you select formulas - It would highlight cells with formulas.
If you select formulas and error option under forumla - It would highlight errors in forumlas like -#N/A, #Name? etc.
If you select blanks, It would highlight only blank cells
Once the cells are highlighted, you can fill color in the selected cells. Once a color is filled you can use the filter command and filter only colored cells.
The dialogure box which appears is attached.