How-To Geek on MSN

I use these 7 Excel shortcuts to find and fix spreadsheet errors in seconds

Instead of selecting all errors, press F5 > Alt+S > C > Enter to highlight all constants—numbers, text, and symbols that aren ...
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 ...