Excel Keyboard Shortcuts Every Data Analyst Must Know

Best Online Course : SAS Programming with 50+ Case Studies

- Explain Programming Concepts in Simple English
- Live Projects & Case Studies
- Job Placement Assistance
- Get 10% off till Sep 11, 2017
- Batch starts from October 8, 2017

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

Excel Tutorials : 100 Excel Tutorials

About Author:

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has close to 7 years of experience in data science and predictive modeling. During his tenure, he has worked with global clients in various domains like retail and commercial banking, Telecom, HR and Automotive.

While I love having friends who agree, I only learn from those who don't.

Let's Get Connected: Email | LinkedIn

Get Free Email Updates :
*Please confirm your email address by clicking on the link sent to your Email*

Related Posts:

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

  1. seems to be useful but has to remember a lot

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

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

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

  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

  6. Thanks a lot for this lecture

  7. think there's more about the shortcut unmentioned

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


Next → ← Prev