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

Spread the Word!
Share Share Tweet

About Author:
Deepanshu Bhalla

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

While I love having friends who agree, I only learn from those who don't
Let's Get Connected Email LinkedIn

19 Responses to "Excel Keyboard Shortcuts Every Data Analyst Must Know"

UnknownFebruary 20, 2015 at 11:02 PM
seems to be useful but has to remember a lot
Deepanshu BhallaFebruary 21, 2015 at 4:56 AM
Start with "Basic" shortcuts , then jump into a long list of "Productivity Boosting keyboard" shortcuts.
UnknownJune 26, 2015 at 7:30 PM
Hi Deepanshu, great work done till now...but waiting for your ANOVA and Regression which are awaiting
UnknownJuly 29, 2015 at 3:03 AM
Hi All....can anyone tell How to unhide Status bar in Excel?
UnknownDecember 3, 2015 at 8:41 PM
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
UnknownNovember 17, 2016 at 3:06 AM
Thanks a lot for this lecture
UnknownApril 21, 2017 at 8:05 AM
Super site
UnknownJune 28, 2017 at 3:13 PM
think there's more about the shortcut unmentioned
AnonymousSeptember 13, 2017 at 12:25 PM
cntrl+Shift+L for turn off and on filters
AnonymousSeptember 28, 2017 at 5:18 AM
Clear filer is not Alt D F S -> it is Alt D F F
AnonymousSeptember 28, 2017 at 5:21 AM
Ctrl + Down = Fill down is wrong
It is
Ctrl + D = Fill Down
AnonymousOctober 5, 2017 at 8:09 AM
Correction:
Alt D F F = toggle filtering on/off
Alt D F S = shows all filtered rows, without actually turning filtering off
UnknownOctober 20, 2017 at 9:41 AM
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.
UnknownAugust 25, 2018 at 9:30 AM
its very helpful. Thank you so much deepanshu bhalla
god bless you sir
Saddam bashaSeptember 18, 2018 at 10:03 AM
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..!......!...
Dr.Ratheesh Kumar May 8, 2019 at 11:05 AM
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
UnknownJune 5, 2019 at 11:12 PM
This is very useful.
UnknownNovember 17, 2021 at 11:44 AM
great