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 that Cell is not in Edit mode or Enter mode. But the Cell contents of the Active Cell are displayed in formula bar.
Refer below image. There are formulas in Cells E2 to E7. But, you can see only the result of the formulas in those Cells. But, E7 is the Active Cell and the formula stored in Cell E7 is diplayed in formula bar.
Written by Jajish Thomas.
Last updated on 28th January, 2022.