Forum Index
shamskm.com Home
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How to show or display formulas in Excelsheet

 
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum
View previous topic :: View next topic  
Author Message
Admin
Site Admin


Joined: 25 Sep 2007
Posts: 272

PostPosted: Sun Mar 12, 2017 6:17 pm    Post subject: How to show or display formulas in Excelsheet Reply with quote

There are several ways to show or display formulas in Excelsheet:


Go to the Formulas tab > from the Formula Auditing group click on the Show Formulas button. It will show you the formulas.





If you click on Show Formulas again (it's a toggle button), your calculated results will be displayed. So toggle on and off (the Show Formulas button) to show and hide the formulas Smile.




2nd Option:

Use the keybord shortcut: CTRL + ` (grave accent)

Press again CTRL + ` to display the results only.




3rd option: - to see formulas in single cells only

Select the cell and hit "F2" on your keyboard. Press "Esc" to get out of it.






Have fun Smile





*Recommended:


Read wonderful articles (English & German) on Science & Tech, Environment, Health and many other topics only on BlogArena.


For comments of suggestions, please contact us: info@shamskm.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group