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