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 4. Total comments: 109

  1. Nice information

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

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

  4. ‘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

  5. 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

  6. very useful

  7. thnxs to help us

  8. Thank u so much

  9. excel shortcut key

  10. How Can One Insert Numbers Automatically

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

  11. Dear Respected Sir,

    Please get me work easy way to do the excel sheet with all functions with total solution to do my daily reports and invoices multi national company on going jobs.

  12. RAMNATH DIGHULE

    I HOPE
    I TO I
    MY LARNING I HOPE YOU.....

    THAKU FOR TOU

  13. I AM MY BEST KNOWLDGE OF EXELE

  14. It's very helpful.I can use the excel more faster.Thank you very much.

  15. Great to know.

  16. As'Salam-o-Alaikum
    Very Instructive and must for every Excel user
    Highly Recommended
    I wanted to include an Important one for VBA Programming
    Alt+F11 to open VBA(Visual Basic for Applications)IDE

  17. my 20 to exsl untfortun due volume fo commetsrccived

  18. good,

  19. thanks so much,very helpful

  20. i need vlookup formula in shortcut to complete the work fast....

  21. what is the shortcut key to Vlookup

  22. yes it is very beautyfull shartcut evaryone persons you's fully then better

  23. Very helpful,easy to understand & remember shortcuts.
    Hope for more shortcuts soon.

  24. thanks its very useful formulas

  25. It was really helpful. Thanks a ton for this awesome content made available.

  26. Its very nice though an good job

  27. Explained is good but Pls put some example images of particular shortcut keys.Thanks

  28. Thanks a lot :) very helpful, KUDOS!

  29. very useful

  30. Dafur you are wasting your time

    1. I love this app thank u its nice and helpful

  31. very useful thanks a lot...

  32. short cut key on mail in and daily tip

  33. This is nice shortkut key in excell thanks for add this

  34. very useful very helpful
    Thanks a lot

  35. Good job

  36. Your teachings are a value addition to me. May Allah blessed his mercy on you with rejoicings of this world and the heaven.
    Regards

  37. this is nice...all the information that i have been looking for are all in here... ♥♥♥

  38. Thank's

  39. very helpful, much better than watching the videos.
    thankx much'

  40. excel most important daily useful key send my email ID. please

    1. i want excel shorcut

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