Excel Keyboard Shortcuts Every Data Analyst Must Know

If you fancy yourself a Excel power user, you know how valuable it is to keep your hands on the keyboard. Apart from making you work more efficiently and faster, you can also impress your friends or colleagues by being able to work without a mouse.

What Top Analysts Think About Keyboard Shortcuts?
If you can do it with a keyboard shortcut, there’s no reason to do it with your mouse.





Paste to left  : Go to the left cell and type ALT + E + I + L
Paste Up       : Go to the left cell and type ALT + E + I + U
Clear Filter    : ALT D F S
About Author:

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 8 years of experience in data science. During his tenure, he has worked with global clients in various domains like Banking, Insurance, Telecom and Human Resource.

Related Posts:
19 Responses to "Excel Keyboard Shortcuts Every Data Analyst Must Know"
  1. seems to be useful but has to remember a lot

    ReplyDelete
  2. Start with "Basic" shortcuts , then jump into a long list of "Productivity Boosting keyboard" shortcuts.

    ReplyDelete
  3. Hi Deepanshu, great work done till now...but waiting for your ANOVA and Regression which are awaiting

    ReplyDelete
  4. Hi All....can anyone tell How to unhide Status bar in Excel?

    ReplyDelete
  5. Hi Deepanshu Bhalla, i would like to thank you for providing this site to Analysts.And we are waiting for new posts from you.so please keep updating info about Analytics.........

    Once again Thanking you....Deepanshu....Good luck

    ReplyDelete
  6. Thanks a lot for this lecture

    ReplyDelete
  7. think there's more about the shortcut unmentioned

    ReplyDelete
  8. cntrl+Shift+L for turn off and on filters

    ReplyDelete
  9. Clear filer is not Alt D F S -> it is Alt D F F

    ReplyDelete
  10. Ctrl + Down = Fill down is wrong
    It is
    Ctrl + D = Fill Down

    ReplyDelete
  11. Correction:
    Alt D F F = toggle filtering on/off
    Alt D F S = shows all filtered rows, without actually turning filtering off

    ReplyDelete
  12. The taking care of information issues turns out to be simple for everybody by making of this activewizards.com which makes the information researcher accessibility simple for everybody. Since the best information researcher dependably helps you to deal with your huge and immense information which isn't overseen by you.

    ReplyDelete
  13. its very helpful. Thank you so much deepanshu bhalla
    god bless you sir

    ReplyDelete
  14. I think.. this.. is .. the..one .. of.. the.. amazing ..sites..now-a-days and it will stand in top..in ..couple..of.. months..
    Thank u..Deepanshu..Bhalla.....
    All the best..!......!...

    ReplyDelete
  15. hi Deepanshu congrats its a wonder ful site for beginners. i have updated my base in SAS predictive analytics and R program from your site.Thanks alot

    ReplyDelete

Next → ← Prev
Love this Post? Spread the Word!
Share