Display formulas in Excel

Ever need to look through the formulas on a spreadsheet?  Maybe you need to update them, maybe you're trying to fix a problem or maybe you just want to know what's going on.  Sure you can go through and click on each cell to show the formula but did you know you can set Excel to show the formulas instead of the values in the regular display?

Select the Formulas tab and click on the Show Formulas option.  Now, instead of showing the results, Excel will display the formulas themselves for the entire spreadsheet.  Since the formulas are often longer than the results, the columns may also automatically resize to be able to display the formulas. 

When you're done, just click on Show Formulas again and the spreadsheet will go back to showing the results.  It will also automatically resize the columns back to their original settings.