How to show or display formulas in Excelsheet

Forum to talk about all the latest technologies - ins and outs!!
Post Reply
Admin
Site Admin
Posts: 325
Joined: Tue Sep 25, 2007 12:41 pm

How to show or display formulas in Excelsheet

Post by Admin »

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.


Image


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 :-).




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.


Image



Have fun :-)
Gideon Auer
Posts: 1
Joined: Wed Aug 19, 2020 8:23 am

Re: How to show or display formulas in Excelsheet

Post by Gideon Auer »

Since I am a beginner who has just entered into the beautiful world of Microsoft Office, getting these tips means a lot for me. Now I have read big assignments australia reviews and learned a very useful trick of displaying formulas in the Excel sheet.
Post Reply