Excel tip: show formulas in cells instead of values to help troubleshooting

Having trouble with a formula or trying to learn the formulas used on somebody else's worksheet?  Use "Show Formulas" to show formulas instead of values.

"Show Formulas" is a toggle that can be found on the Formulas tab in the Formula Auditing group.  When in Show Formulas mode, clicking on a cell highlights the cells used in the formula for easy viewing.  Turning off the toggle returns to normal viewing mode.