Sometimes when you have a large size of worksheet and you have applied a lot of formulas and functions in it and in some cases you need to view you formulas. Ooops ! the first thing comes in ones mind is "How to show all formulas"? Well this is pretty easy but need to do followings; |
Open your Microsoft Excel Worksheet and with a quick key combination from keyboard, you can view your formulas; |
 |
Ctrl key and Tide key on your keyboard, as shown above |
 |
If you need to hide your forumlas, just again Press key combination and all formulas will be hide. This key combination is a great thing to correct and check your cells for formulas. |
Comments
Post a Comment