Show formula in Excel in specific cells without activating show formula
option:
Someone asked me about following table. How the Expression column in
this table shows formula without activating Show formula option in Formula
Tab à Formula Editing? In this column he
access any cell in edit mode after lock the entry in the cell Excel shows the
result instead of underlying value in that cell.
I solve above mention
problem in following steps:
If you want to show
formula in excel cell first select the cells 
Then convert its category
General to Text
After that type the
formula: this formula extract Title from the Name of the Student
Now you are able to
view the formula. If you want to convert it into formula to calculate by Excel
you select the cells again
And convert its
category text to general
Active any cell in
expression column and press F2 key
and press Enter key
Excel now calculate it.
Or if there are
already formulas in cells and you want to view it without using the show
formula option/ (Ctrl+`) (`acute accent key) or you want to view only specific cells not all
in the sheet:
Step1: select the cells
Step2: change their
category into Text
Step3: make it active
and press F2 and lock the entry
Now it will show the
formula……….
Tell us what we can do to improve this article
Please comment if you like it, or have any
suggestions.
suggestions.
