Comments on: 30 most useful Excel keyboard shortcuts

Learn the most useful Excel keyboard shortcuts to manage workbooks, format data, work with formulas, navigate between worksheets and more. Continue reading →

Comments page 2. Total comments: 109

  1. Put Formula "RANDBETWEEN"
    =Randbetween(100,200) now you will find numbers between 100 to 200 automatically.
    Now select the area in which you want to paste it and use Ctrl+D and Ctrl+R.

  2. Very Nice...!!!

  3. Very...nice...
    Very..useful

  4. Awesome Sir .

  5. Very useful

  6. Excellent Info and shared in a most desired way.
    Thanks for charity.

  7. Crtl+o
    YOU OPEN MY HEART.

  8. Wonderful Day to Day useful tips

  9. Thank you so much for your feedback.

  10. Really helpful ..... please give pictures of keys if possible❤

  11. Thanks

  12. You may use these shortcuts.
    ALT + A + G G (Group)
    ALT + A + U + U (Ungroup)
    Alt + A + R + A (Refresh All)
    ALT + A + C + W (Unfilter All)
    ALT + E + S + V (Paste as Value)
    ALT + E + S + F (Paste as Formula)
    ALT + O + H + U (Unhide Sheet)
    ALT + O + H + H (Hide Sheet)

    Hope this could help you alot!

    1. Thanks

  13. Very useful notes

  14. very useful notes

  15. thanks..helpful

  16. what is the shortcut key of vertical lookuo or hlookup in m.s. excel

  17. useful and helpful

  18. I loved it

  19. The keyboard shortcut to format a cell's value as a percentage is: Ctrl+Shift+%

  20. What combination keys turn the value in a cell into percentage?

  21. Plz mail me this shortcuts keys data

  22. Very useful this excel keys detail

  23. Plzzz sent most useful formulas of excel for company job into my mail I'd,shortcut keys also

  24. Very useful daily use shortcuts.

  25. This is a good for every one if any person has interest in Excel program ......

  26. thanks for sharing this.it is very helpful

  27. VERY USEFULL

  28. Thanks alot for your help

  29. Thanks my man. You made me look good at work.

  30. Thank You
    You were very helpful

  31. Hmm good

  32. Dear Team,

    These Shortcut keys of excel is a basic keys that every excel Worker knows very well.

    Note:- You need to improve and you have to provide us best excel shortcut keys which is useful for us.

    Thank You!!

  33. these are shortcut key of excel very useful. Thanx a lottttt

  34. Want very usefull shortcut keys use in exel plz send me ok
    Send on my whatsapp no.
    8090636724
    Plz bro in 2-6 days ok

  35. please i need shortcut to change from lower case to upper case in excel

  36. usefull

  37. very usefull

  38. thanks for a wonderful help.

  39. Thanks for give sort keys

  40. ctrl home,
    ctrl shift end
    will change my life!!!

    1. Hi ctrl + o
      You open my heart.
      Tnx alot

  41. Nice information

  42. Great list!! Helpful quick tips. The select data ones were new to me. Thanks!

  43. Could u like to teach me how to insert phone number which starts with Zero in excel cells .
    How can I insert long name or information in a cell but it will show same size cell ? .....waiting for ur reply ...........

    Thanks

    1. 1.Put apostrophe before inserting number.
      2.Home - Format - Autofit Column Width.(You can use the shortcut - Alt+HOI)

  44. ‘Excel shortcuts and tricks’ is my favourite topic and I love them. Apart from keyboard shortcuts I also love using something called ‘ribbon shortcuts’ – press F10 or Alt to start with, then select the letter displayed accordingly to get the command you want. After a little practise, the steps should be able to memorised and performed quickly from head – this is much faster than clicking using the mouse.

    For example:

    F10, W, F, F – to freeze/ unfreeze panes
    F10, A, C – to clear all filters

  45. Very nice.It's very helpful to everybody.

    1. Some shortcuts that I use everyday but not listed in the first post:

      Ctrl + Shift + L (to apply/ remove filter)

      Ctrl + B / I / U (don’t need to explain do I?)

      F7 (spell check)

      Ctrl + roll the mouse wheel (zoom in and out)

      Hold down Ctrl, click hold a worksheet tab, drag across to the right hand side, release the mouse then release the Ctrl key (this duplicates the current worksheet instantly on a new tab, surprisingly useful in some situations)

      Also, customized the quick access toolbar to my exact requirement, place it below the ribbon, and hide the ribbon (Ctrl + F1) – this is my Excel layout

  46. very useful

  47. thnxs to help us

  48. Thank u so much

  49. excel shortcut key

  50. How Can One Insert Numbers Automatically

    1. Write 1 and 2, then select both the Cells and drag the selection downward.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)