Excel Keyboard Shortcuts Pros Swear By to x10 PRODUCTIVITY
HTML-код
- Опубликовано: 22 июл 2024
- 20 Excel Keyboard shortcuts Excel Pros swear to dramatically speed up your workflow and increase your productivity.
Get our free 239 Excel Keyboard shortcuts PDF here: www.myonlinetraininghub.com/e...
🔻 DOWNLOAD EXCEL FILE FOR THIS VIDEO HERE: www.myonlinetraininghub.com/2...
🎓 LEARN MORE in my Excel courses: www.myonlinetraininghub.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
⏲ 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 Наука
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.
Wow, that's awesome to hear!
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 !
So pleased to hear that it was worth your time to watch 😁🙏
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!!
Thanks for your kind words, Tony! I'm delighted you're finding value in my videos.
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.
Great to know you can make use of it :-)
I saw 1st Shortcut and I clicked on Like.
For Me, it has been a big, big challenge.
Gratitude!
So pleased you found some Excel keyboard shortcuts you can use, Ankur :-)
I hit the like button by the end of the first shortcut, paste values is my best friend in work. I reckon I probably only knew about 25% of the rest but will be having fun showing off when I get in tomorrow. On a related note, my almost 70 year-old mother recently brought F4 to my attention! She's been using spreadsheets as long as I have (back as far as Ability Office on a 640K 8086 Amstrad PC1512 running MS-DOS 3.2) and she's still capable of teaching me new tricks (also, I blame her for my Excel geekery).
Keep up the great work, I only recently discovered your channel but they've been such a help and given me whole new ways of working more efficiently, thank you.
Thanks for your kind words! I'm so pleased it was worth your time to watch the video. :-)
Thanks a Bunch Mynda, Loved your Dashboards video and subscribed. God Bless for all your efforts in Educating the Excel Rookies.
Great to have you subscribe, Satinder :-)
I don't know how I got your emails earlier this year, but now with COVID-19 I am starting to look at your material. Very impressive and I will be viewing more. Thank you so much. On this particular Excel shortcuts video, some of these will be extremely useful.
Great to hear you can make use of the tutorials, William. Please share them with your co-workers who might also have time on their hands :-)
Great tips! As always Mynda reminding us how to make excel and life easier!
Thank you Mynda!
My pleasure, Felipe :-)
I´m a lover of shortcuts, and these are the best shortcuts I´ve never seen. Congratulations!
Wow, thanks! Glad you like them, Alejandro :-)
What I use everyday ctrl + 1. And I love your tip with alt + E S V. 👍 Didn't know this. Thx for charing your "sectrets" with us.
Great to know you discovered some shortcuts you can use :-)
Thanks for sharing your “secrets”, Mynda. Shortcuts makes more joyful when you work with excel...
You're very welcome, Vincent!
Excellent tutorial of shotcuts. What a gift!!! Thank you Mynda!
Hope you discovered some new ones.
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.
Thanks for sharing your Copy as Picture tip, Adam! I'll definitely be using that :-)
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
Great to hear!
omg Christmas came early this year!! at 6:38 i was in awe but at 16:06 you just blew my mind! this will save me soooo much time! thank you very, very much!!
😁 great to know you enjoyed it!
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 :):):)
Glad you found a tip you can use, Darryl :-)
As I am a pro user, I already know all the shortcuts but your all shortcuts are really very handy and I also use it everytime. These are really a pro user shortcuts, as per my experience also.
Glad you agree, Rohit :-)
Very good tips! The shortcut to check the formulas is amazing!
Great to know you found some you can use :-)
Thanks Mynda as always.
I use ctrl+shift for quick cell formatting:
ctrl+shift+1 = format as number
ctrl+shift +$ = format as currency
ctrl+shift +% = format as percentage
I also use ctrl + # to format as date (dd-mmm-yy). Having the month as a word instead of number helps ensure the format is correct (us mm/dd/yy vs uk dd/mm/yy)
Love those ones too, Laurent! Thanks for sharing :-)
Noted, Laurent!
Thank You!
Thanks for the great tips, Laurent!
Thanks for the video, actually learned several shorcuts I had no idea were available. Shorcut #8 did make my mind blow.
:-) great to hear.
Definitely the arrows in the dialogue box!! So, soooo frustrating …. That one is life-changing for me ❤
So glad you can make use of that tip. It still trips me up sometimes, but at least I know how to fix it.
i really enjoyed these jumping short cuts at the beggining of this video.hahah. thanks for your time and sharing your skills with us....
Glad you like them :-)
Great video! Pressing Menu than V for pasting values or Menu F Enter for pasting formulas, saves some clicks, found that Menu key is quite powerful in different other contexts in many other programs. Deserves testing it all the time.
It's just a shame the menu button is on the right-hand side of the keyboard, which means I have to leave the mouse to click it. If it were on the left I'd use it more. I agree though, it deserves testing all the time :-)
@@MyOnlineTrainingHub Ok, fair enough, then use right click and V, still faster, or 2 finger tap on a touchpad. :-)
@@MyOnlineTrainingHub I just set up AutoHotKey to remap the CapsLock key to act as my (missing) Menu key. I use Filter by Cell Value All.The.Time so I LOVE this tip!!
Atl+a+c fastest way to clear filters. Great video. There were a couple new ones for me!
Thanks for sharing!
Here’s one that I use frequently: Alt + digit (0-9) to launch a quick access toolbar item. For instance, I have Switch Windows in the leftmost position, so Alt+1 displays a list of open windows. Quick, convenient (and the same as the Windows menu before the ribbon was introduced).
Nice, thanks for sharing!
Fantastic! Thank you, TSSC!
Nice! Thank you for sharing!
i also like to use Menu + T (or right click + T) to open number formatting for pivot table values, which after refreshing the pivot table won't take the formatting away.
Thanks for sharing, Kher :-)
How many are from forage?
For me #17 was new and awesome. Thanks for collating all and showing in 1 video
Glad you found a tip you can use, Anita!
Mynda your shortcut secrets are sweet. I am a mouse addict and addictions are hard to break, but you have convinced me. Several favorites but what sold me was the useful "alt + =". I wanted to share a shortcut of something I do often like freezing the top row, but I had to google it. "alt w-f-r". Enjoy your tuts :)
Wow, glad you found some shortcuts you can use and thanks for sharing ALT > W > F > R :-)
Great stuff! I feel good about having a little more than half of these under my belt. Was laughing when I saw you hit the "+" in the bonus, and said "yeah, that's old school." Also, I still use Transition Navigation option, so if you have that selected, you can select contiguous rows, columns, or ranges using Shift+(Arrow key). The other beauty of this, is when cleaning up missing values, End+(Arrow Key) will automatically stop at the next missing value. Too valuable for me to get away from that (very old) option. Thanks very much - you taught an old dog some new tricks!
😁glad you liked it, Bill! I held on to the transition navigation keys for a long time too, but there are equivalents that replace them, e.g. CTRL+arrow key does the same as End > arrow key 😉
Excellent review. I become a fan of your videos. I use often the shortcut Ctrl+Enter. It fills a range of adjacent cells with the same value.
Thanks, Pierre :-)
We are grateful for these excel secrets! Thanks for the post👍
My pleasure 😊
Love the video, thought i knew them all but the F4 key to redo formatting was a nice surprise. Thanks!
Great to know you found something new you can use, Martjin.
Yes that's another favorite
Awesome blown my mind , guys do it on excel while watching simultaneously
So glad you like it! 🙏😊
My new favorites, F2 and ALT+=. I've learnt a lot more though. Thanks for this video.
Glad you can make use of the shortcuts, Muli :-)
your so sweet to share all this thank you so much
You are most welcome!
Thank you for these and all the hard work you put into your videos. They've been really helpful to me.
Happy to hear that!
with drawing object selected, hold the SHIFT key and it will resize in both directions. if already existing, grab one of the corners and hold shift while you resize. if you insert an oval but hold shift while drawing it will make a circle. hold CTRL while dragging and it will resize from the center.
the mouse equivalent of Ctrl+Shift+↓ is to hold Shift and double click on the bottom border of the cell.
snap to grid was one I didn't know. Thanks!
Thanks for sharing, Jonathan!
Ctrl+space and ctrl+shift to highlight a row or column. Blew my mind!
Awesome to know you found a couple of shortcuts you can use :-)
List of shortcuts ! Good ! Your présentation makes it Wonderful ! Awesome...
Thanks so much! 😊
Thank you for the cool shortcuts!
Here are the ones I didn't know before watching this video:
Ctrl/Shift + Space to select column/row
Alt + E + S for Paste special
Ctrl + +/- to insert/delete column/row
Ctrl + D to duplicate values from the row above
Alt + down to open a drop down list
Shift and move to insert data
Ctrl+Shift and move to add data (by replacing in the destination, as it happened in my case)
Ctrl + ` to toggle between viewing data and formula (without formatting)
Ctrl + ; to write current date
Ctrl + : to write current time
Ctrl + T/L to format as table
Alt + = to insert autosum
F3 to insert values based on name (didn't know we could define names to tables and formulas)
Also, didn't know that keep pressing F4 will toggle between various options of absolute referencing.
So, it's been good learning. Thank you, again!
Wow! Great to see you found so many new shortcuts you can use :-)
#9. And I also realised that it would be most convenient to move to diffent worksheet using ctrl+g. I just need to define one named cell to each sheet.
Yes, CTRL+G is super handy too.
Next level copy-pasting...You've more than earned my like and sub!
😁Thanks so much, Paul!
I am quite comfortably a pro. I knew most of these but still met with some surprises. Who knew the Alt = can get you that much. I also never knew any shortcut works with the mouse as I almost despite using it.
Awesome to know you discovered a couple of new tips. Thanks for watching :-)
This will save lifes lol
Thank you for sharing!
Happy to help! 😁
This video is pure gold for me. Thank you so much !
1 concern though I could not make ctrl+backtick work with my French keyboard (which makes me sad). Any idea ?
Great to know you found some tips you can use :-) I suspect the regional settings are limiting the shortcuts for CTRL+backtick.
Thank you. F2 in chart data reference will save me a lot of time. I love also Ctrl + Page Down/Up to jump to another sheet.
Great to know you found some shortcuts you can use :-)
Yes, I used the F2 to edit cell, but didn't know about charts either
This might be the most useful video ever uploaded to RUclips
Wow, thank you!
Your excel knowledge is next level. Not only from this video but in from others I've seen.
Thank so much, Ikaika. Please share the videos with your co-workers :-)
@@MyOnlineTrainingHub No thank you! Haha, you and your channel made me realize that my excel knowledge is outdated.
I'm inspired to brush up and learn some new tricks.
Thank you for the knowledge and inspiration!
Another excellent video.
Glad you enjoyed it, Imran!
Amazing tricks, thank you
Glad you found them helpful 🙏😊
Great Video . . . The Shortcuts I use apart from the ones you mentioned are :
To remove a filter from a column = Menu, E, E
To remove all filters from Worksheet = Alt, A, C
To rename sheet = Alt, H, O, R
To change Sheet Tab Color = Alt, H, O, T
Cell Styles = Alt, H, J
Thanks for sharing, Naveed! I'll definitely be using ALT > A > C :-)
@@MyOnlineTrainingHub Glad to hear that 👍
Wow! great thanks - now only for me to remember them all!
Glad you liked it, Nisha!
Very helpful!
Glad you think so!
Cool very useful👍 thank you 🙏
My pleasure 😊
Hi Mynda - lovely refresher. I am retired now but I stay subscribed to your material because it is just too hard to let EXCEL go lol!
I'm sure I'll be the same once I finally retire :-)
@@MyOnlineTrainingHub Meanwhile, I wish you continued joy and good fortune before that time comes!
Loving the T-shirt 👕 , have a great time
Thanks so much!
Thanks for sharing your knowledge. I want to know the shortcut key to remove or unlink the pivot table but the pivot table format or structure (Table, color, font, design) should be as it is.
You can't unlink a PivotTable, you'd have to copy and paste it as values and keep formatting.
Thank you so much, 90% of the shortcuts I am seeing for the first time. I will saw Vow for most of the shortcuts. Some astonishing shortcuts are F2, Ctrl+Shift+leftclick, Ctrl+T.
Awesome to hear you found it helpful, Vino :-)
@@MyOnlineTrainingHub you are my favourite Excel Star.
very helpful video!
Glad you think so!
Thanks Myndy. These were very helpful. :) :)
Great to know, John :-)
i cannot tell you how much this helps me.
Glad you can make use of the tips :-)
Thank you for sharing such amazing shortcuts. For value paste I hold Alt then H , V , V.
You're welcome and thanks for sharing your paste values shortcut!
I put auto filter and clear filters in the QAT then use the alt 1 or 2 to call them. I like it because I can apply multiple filters in the columns based on the cell value. The clear filter allows me to remove them quickly.
Ooh, I like that one. Thanks for sharing, Rick!
You should do a video on the quick access toolbar. I'm curious to see what you put up there. The first 9 spots are really valuable because their shortcuts are alt + 1 - 9 which are really convenient.
Great idea, Paul!
Thank you ! That will save me some time
Thanks for sharing your secrets!
My pleasure!
it-was-excellent!
😁glad you enjoyed it!
Best excel video of 2020!!! thank you
Wow, thanks, Robert!
Thank you Mynda!!!
My pleasure, Eduard :-)
Thank you so much for sharing!
My pleasure :-)
Very Help full
Glad to hear that 😊
Great Tips! Thank you
Glad you liked them, James :-)
Not an Excel expert but pleased I knew most. ( not all). Like the ALT +
Glad you discovered some new tips you can use :-)
Great shortcuts, thank you so much! Wish I could press F4 and repeat the "thank you" 😊
:-D thanks so much!
Thank you very much for the cool shortcuts
Glad you like them!
For pasting values I use Ctrl-V, Ctrl, v. So three distinct keyboard presses, but very easy to remember.
Thanks for sharing!
thanks for your great video. Can you share more about shortcut for unhide column. This docs mention Ctrl 0 for hide column, regarding to unhide column, this is not mentioned ...
You can use Alt > O > C > U to unhide columns. It's not quite as elegant though.
Thank mam...you are awesome
.👏👏🙏
Thanks for sharing this valuable shortcuts
My pleasure, Saeed :-)
Great video. BTW, the Menu/Application key is sometimes missing (e.g. laptops), but the Shift+F10 is always there, and do the same trick, and of course works in all Windows apps.
Thanks for that!
very usefull shortcuts. thanks for sharing.
my favorite shortcut is alt+; for selecting visible cell only in order to copy and past it in another place.
Thanks for sharing ALT+; :-)
@@MyOnlineTrainingHub your welcome mynda.:)
Excellent, tranks. ⌨⌨🖱🖱🎖🎖🏆🏆🏆
Glad you liked it, Ljudevit :-)
i liked them all... i also use cntrl+0 to hide column
Pleased to hear that, Ayush!
Every time I learn a new Excel shortcut, I feel enlightened. These 20+ shortcuts are so useful. I especially liked #17. Thanks so much!
Great to hear, Prasad!
Thanks for great & quickly skill !
My pleasure, Tery :-)
Thank you!
You're welcome!
CTRL-A-V blew my mind. (same as ALT-E-S, but the CTRL option makes more sense to me.)
Glad you found some tips you can use, Larry!
all shortcuts are awesome.. and I liked your 👕 t-shirt
:-) thanks, Rahul!
Great video! Thanks
Glad you liked it, Terry :-)
Thank you very much, dear teacher.
You're welcome!
CTRL E for flash fill without having to drag the cross, CTRL enter to fill a set of non contiguous selected cells with a value or text - useful for filling blanks after finding them with Go to Special.
So pleased you found some useful tips :-)
Amazing video....very good work...keep up
Thank you, I will 😊
Wicked smart! Work-Life balance saver!
:-D glad you liked it!
Great Content
Thanks so much!
Did not know ctrl +d worked on shapes plus active x objects thanks heaps
Excellent video. Only one I'd add is Ctrl ] to select dependent cells
Yes, great for debugging formulas. Thanks for sharing!
I love 'Alt + Enter' to repeat the last command you did.
Hey John, ALT+ENTER in edit mode inserts a carriage return/line break. F4 repeats the last command.
loved it
🙏
Well, Alt + Down was nice. The one that I would recommend is "Ctrl + ." It helps you switch between the corners of a highlighted area. Very useful when pasting data - to get to the last pasted row/column.
Thanks for sharing :-)
Hi,
I tried to use Your recommended shortcut: Ctrl +. But, nothing happened. Request You to help Me understand the shortcut again.
yay, love the Ctrl + . Thanks!