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

Hi User, Thank You for Visiting My Blog. Please Post Your Feedback/Comments/Query.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts