How-To Geek on MSN
I stopped worrying about spreadsheet audits when I discovered this hidden Excel wizard
Hard-coded numbers (also known as constants) being mistaken for formulas is a serious audit risk because they can lead to inaccurate results when inputs change. Luckily, the Go To Special wizard can ...
Instead of selecting all errors, press F5 > Alt+S > C > Enter to highlight all constants—numbers, text, and symbols that aren ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results