Joined: 25 Sep 2007
|Posted: Sun Mar 12, 2017 6:17 pm Post subject: How to show or display formulas in Excelsheet
|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 .
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.
Read wonderful articles (English & German) on Science & Tech, Environment, Health and many other topics only on BlogArena.
For comments of suggestions, please contact us: email@example.com