Wednesday, 15 August 2012

How to Display or Hide the Formulas in a Worksheet

How to see the Formula in a Cell itself without going for Formula Address Bar
Suppose we have data and formulas in a sheet. If you want to see the formula without going to Address bars , simply you can put one space before the formula then you can see the formula in the cell it self as shown below :


If you want Display or Hide all the formulas in a sheet , you can use the following short cut key :

Ctrl + ` ( Control+ Apostrophe/Grave Accent)  



No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts