How to See the Formula in Excel?

Select the cell containing the formula

View the formula in the Formula Bar

Press Ctrl + ` to show formulas in the worksheet

Go to the Formulas tab

Click Show Formulas

Double-click the cell to edit and view the formula

Use F2 to edit and inspect the formula in the cell

Check the Name Box and Formula Bar for the active cell’s formula

Suggested for You

Trending Today