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.
