Excel Keyboard Shortcuts Pros Swear By to x10 PRODUCTIVITY

20 Excel Keyboard shortcuts Excel Pros swear to dramatically speed up your workflow and increase your productivity.

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

💬 Please leave me a COMMENT. I read them all!

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

⏲ TIMESTAMPS
0:00 Introduction
0:36 F2 in Dialog Boxes
1:23 Paste Values
2:12 Paste Formulas
2:51 Select Rows & Columns
3:17 Insert & Delete Rows & Columns
4:28 Select Cells and Ranges
5:52 Select Objects
6:23 Move Rows & Columns
7:21 Filter
8:35 Navigate Workbooks
8:59 Tables
9:29 Duplicate
10:16 Align Objects
11:28 Format
12:03 F4 Tricks
13:35 Defined Names
14:28 Display Formulas
15:31 Drop Down Lists
15:55 AutoSum
16:50 Insert Dates & Time
17:18 Bonus Shortcuts

[AlDunbar]

Videos like this are much more useful than a simple list of shortcuts and their effect.

I have often thought it would be good to know or have a list of all the shortcuts available in excel, Word, zoom, windows and etc. But the only value of a shortcut is that it is shorter than its explanation and can be used without having to look it up each time, so I usually pick only those I know will be immediately useful, and make a point of trying them out.

This video was great as I made note of more than half of them.

[tsalb]

That named ranges selector is going to be a game changer for me.
I love having my common excel shortcuts on keyboard macro keys so they’re even faster.

[avvabaldur]

Definitely, you are a proficient user of Excel. The Alt + Drag/Drop object was surprising. That was the only one i didn't know. I can't name how many things I've learnt from your videos. Thank you so much. All the best !

[felipe]

Great tips! As always Mynda reminding us how to make excel and life easier! 
Thank you Mynda!

[satindersingh]

Thanks a Bunch Mynda, Loved your Dashboards video and subscribed. God Bless for all your efforts in Educating the Excel Rookies.

[vincentlivera]

Thanks for sharing your “secrets”, Mynda. Shortcuts makes more joyful when you work with excel...

[JAAP]

I´m a lover of shortcuts, and these are the best shortcuts I´ve never seen. Congratulations!

[shivanshujain]

loved the Ctrl+1 formatting trick. makes it very easy to use dates in various formats and to switch between currency and accounting formats. thanks a lot

[IvanCortinas_ES]

Excellent tutorial of shotcuts. What a gift!!! Thank you Mynda!

[aviman]

Hi Mynda. You wanted to know which shortcut grabbed my attention. Has to be No. 1. What a revelation!! The problem wity shortcuts is that you can quickly forget them or, at least, I do. This is the third video of yours that I have watched and they're nothing short of amazing. I don't think there's a redundant word amongst them. You are so gifted and you have my heartfelt thanks for taking the time to produce these videos and for free!!

[ankursharma]

I saw 1st Shortcut and I clicked on Like.
For Me, it has been a big, big challenge.

Gratitude!

[giaizen]

Very good tips! The shortcut to check the formulas is amazing!

[rhrmentor]

i really enjoyed these jumping short cuts at the beggining of this video.hahah. thanks for your time and sharing your skills with us....

[virtualshift]

Thank you for these and all the hard work you put into your videos. They've been really helpful to me.

[roizengh]

Thanks for the video, actually learned several shorcuts I had no idea were available. Shorcut #8 did make my mind blow.

[rmmccarthy]

We are grateful for these excel secrets! Thanks for the post👍

[anitaarya]

For me #17 was new and awesome. Thanks for collating all and showing in 1 video

[darrylmorgan]

Hi Mynda!Excellent Tutorial, Really Helpful.Loved the Filtering By Cell Value Tip "MENU E V" Really Blew Me Away!!I Will Definitely Be Experimenting Using The Menu Key.Thank You :):):)

[Donkeys_Dad_Adam]

Great GREAT stuff! I knew probably 15 of these, but saw some great new ones. I hadn't encountered using the menu key in conjunction with other keys as a shortcut before and also #8, Cut/Copy rows or columns using SHIFT or CTRL+SHIFT. I can see using that one a lot!


I have one for you that you may not have seen before; I often have to grab content from a spreadsheet and copy it as a jpg image into a Slide, or other kind of document. Until recently, I've used the snipping tool for that. I learned that you can select a group of cells in Excel and on the Home Ribbon, click the dropdown arrow for Copy, then select "Copy as Picture", then select the options on the popup. You'll end up with a clean jpg image of whatever you had selected which you can then paste into something else. Much quicker than snipping and cleaner, no overlap, and the aspect ratios are maintained as you resize the resulting image.

[quishasalaskar]

your so sweet to share all this thank you so much