How-To Geek on MSN

How to use the FORMULATEXT function in Excel

The simplest use of the FORMULATEXT function is straightforward formula auditing.
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 ...