How do you use Excel's Go To Special for audit?

Go To Special can select constants, formulas, blanks, visible cells, errors, precedents, and dependents. Use it to find hardcodes in formula areas, blanks in calculation blocks, formulas with errors, and inconsistent row logic. It is especially useful before handoff to catch hidden constants and broken formulas.