Did you ever face problem in differentiating value cells from the cells having formulas? Did you ever mistakenly replaced the formula cell with a value because you didn't remember it had a formula?
Well. by default excel display results of the formula in the cell to which formula is set. You can toggle between result view and formula view very easily.
Select "Show Formulas" option from the "View" menu and your worksheet will display formulas in the cells instead of displaying result of the formula.
Short cut for this is Ctrl + `.
Well. by default excel display results of the formula in the cell to which formula is set. You can toggle between result view and formula view very easily.
Select "Show Formulas" option from the "View" menu and your worksheet will display formulas in the cells instead of displaying result of the formula.
Short cut for this is Ctrl + `.
This is how you will see a difference in the worksheet on selecting "Show Formulas" option.
In a Normal View where results for Formula are displayed:
In "Show Formula" mode where Formulas are displayed instead of result:
In a Normal View where results for Formula are displayed:
In "Show Formula" mode where Formulas are displayed instead of result:
No comments:
Post a Comment