Tip 174 – Instantly View Excel Formulas Instead of their Results

When studying or troubleshooting an Excel worksheet it can help to view the cell formulas rather than the results. To do this, click the Formulas tab and click Show Formulas € you may need to widen the columns to see the full text of long formulas. Click this icon again to return to viewing formula results.