Display all formulas instead of their output values. This allows you to quickly troubleshoot issues in a worksheet without having to select each cell individually. Go to the Formulas tab and click the Show Formulas button: Now, your worksheet will look like this: As you can see, this lets you quickly see what formulas and functions are contained w ...
Added: Feb 25, 2016