Microsoft Excel Tutorial for Beginners #30 – Show Formulas on a Spreadsheet

Visit MotionTraining at http://www.motiontrainingweb.com and https://curious.com/motiontraining where you can interact with lessons and download practice fil…

Don’t forget to check out our other video tutorials or share this video with a friend.

0 votes

Loading... 3,681 views

17 responses to “Microsoft Excel Tutorial for Beginners #30 – Show Formulas on a Spreadsheet”

1. CharCharPLUR says:

   26/12/2013 at 1:51 pm

   What happen if I want to display only one cell’s formula? Is there a method
   to do that?

   Reply
2. Peter Lelkes says:

   26/12/2013 at 2:04 pm

   I googled and found out that the keyboard shortcut is: “CONTROL + GRAVE
   ACCENT (`)” The ctrl-key is (at least on a Swedish keyboard), the 2nd key
   to the left from “apple” Unfortunately, the shortcut does not work for me
   either 🙁

   Reply
3. Desire Phillips says:

   26/12/2013 at 2:34 pm

   Your tutorials are quite good. You explain things in plain and simple
   English. There is only one observation: the values on the column Rentals
   (Average, Max, Min) should not have the pound sign before it. They are not
   currency values, but quantities. I am sure you have noticed this before, it
   is just to alert viewers to it, as some might not know it or notice it.
   Thank you very much for making such valuable tutorials available at You
   Tube.

   Reply
4. xxcart kristen says:

   26/12/2013 at 3:33 pm

   thank you!

   Reply
5. Jroccc8181 says:

   26/12/2013 at 4:06 pm

   Thanks for creating 2010 videos for beginners

   Reply
6. dm Ji says:

   26/12/2013 at 4:25 pm

   You are the best tutor ever!!!

   Reply
7. hassan anwar says:

   26/12/2013 at 5:20 pm

   Thank you

   Reply
8. 1020eugenia says:

   26/12/2013 at 6:06 pm

   thank you

   Reply
9. Murthala Shafiul says:

   26/12/2013 at 6:30 pm

   Very nice tutorial for every one

   Reply
10. zincis says:

    26/12/2013 at 6:49 pm

    Thanks for the tutorials, looking forward to next one…

    Reply
11. gladys Kays says:

    26/12/2013 at 7:35 pm

    thank you so much for all these tutorial.. you are the best teacher ever..
    God Bless 🙂

    Reply
12. KDCAL500 says:

    26/12/2013 at 8:25 pm

    I don’t know what the “spare key” is on my mac keyboard. Can anybody help?

    Reply
13. KDCAL500 says:

    26/12/2013 at 8:48 pm

    Still not working for me. I’ve tried every kind of key on the keyboard. On
    Macs don’t have Ctrl. Next to the Z is shift. Are American keyboards
    different?

    Reply
14. MotionTraining says:

    26/12/2013 at 9:36 pm

    On the Mac keyboard I believe the show formula shortcut is Ctrl + ` (that’s
    the key just to the left of the ‘Z’ key). Use the same shortcut to hide
    formulas. Hope that helps & thanks for watching.

    Reply
15. Ashish Rawat says:

    26/12/2013 at 10:25 pm

    Thanks 🙂

    Reply
16. TheZEROpointTHREE says:

    26/12/2013 at 10:51 pm

    Yes ur best than my teacher thank you bro

    Reply
17. wwjd526 says:

    26/12/2013 at 11:49 pm

    THANK YOU!!!!!!!!!

    Reply