Search

How to find an Excel Cell contains a formula or value

When we look at an Excel Worksheet, it is impossible to tell that a Cell contains formula or value. Excel will display only the result of the calculation inside a Cell, if the Cell is not in Edit mode or Enter mode.

Refer below image. There are formulas in Cells C5, D5, E5 and F5. But, you can see only the result of the formulas in Cells C5, D5, E5 and F5.

formula-not-visible-excel-cell.jpg

If the Cell is in Edit mode or Enter mode, the formula is visible inside the Cell. If you want to see the formula inside a Cell, if the Cell is not in Edit mode or Enter mode, make the Cell active by clicking on it and then check the formula bar.

formula-visible-excel-formula-bar.jpg

Related Tutorials
Cell reference (Cell address)
Range reference
What are Excel formulas
How to write formulas in Excel
How to see all formulas in Excel sheet
Mathematical operators in Excel
Comparison operators in Excel
Concatenate (&) text operator in Excel
Cell or range reference operators in Excel
Union and Intersection of Excel ranges
Operator Precedence in Excel
How to change the operator precedence in Excel
Error messages in Excel Formulas
Hash error in Excel (#### in excel)
Multiple parenthesis in Excel formulas
Trace error in Excel formulas
How to remove trace error arrows in Excel
Relative and absolute reference in Excel
F4 key in Excel formula
Mixed Cell reference in Excel