How do you display formulas in Excel
By
SpreadCheaters
Page last updated:
04/01/2023 |
Next review date:
04/01/2025
You can watch a video tutorial here.
Excel is widely used for calculations and can be used to create complex formulas. When studying an Excel sheet with a lot of columns that have calculated values, it is useful to see the formulas to understand how the calculations have been done.
Step 1 – Check if the cells have formulas
– Select a cell
– Check the Formula bar to see if it contains a formula
Step 2 – Show the formulas
– Go to Formulas > Formula Auditing
– Click on Show Formulas
Step 3 – Check the result
– Formulas are displayed in those cells that contain formulas
