Excel Shortcuts that Will Save You Hours of Work (Windows & Mac)
Ғылым және технология
Most common Excel shorcut keys you should know to work faster.
➡️ FREE 239 Excel Shortcuts for Windows & Mac: bit.ly/shortcuts240225
👩🏫 Improve your productivity in Excel with my courses: bit.ly/courses240225
Do you know there are over 270 Excel keyboard shortcuts? It's a lot and I'm not going to cover all of them in this video. Instead, I'm going to focus on sharing the most useful ones to both Windows and Mac users to supercharge Excel skills.
LEARN MORE
===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: www.myonlinetraininghub.com/e...
🎯 FOLLOW me on LinkedIn: / myndatreacy
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
#ExcelShortcuts #Excel #ExcelTutorial
Пікірлер: 73
❓Which Excel shortcut do you use the most? FREE 239 Excel Shortcuts for Windows & Mac: bit.ly/shortcuts240225
@shakiraasfoor7599
4 ай бұрын
ctrl a ctrl c ctrl v ctrl t
@user-jj1er3tu1h
3 ай бұрын
Alt shift f3
@shakiraasfoor7599
3 ай бұрын
what does it do@@user-jj1er3tu1h
It's great to see you back up and running. I need to convert ranges with formulas to values almost daily. I right-click on the selected range that has formulas and drag it to where I want it and then choose Copy Here as Values Only,
@MyOnlineTrainingHub
4 ай бұрын
Oh yes, I forget you can do that too. Thanks for sharing 😊
This is exactly what I'm looking for! Thank you so much🥰
@MyOnlineTrainingHub
10 күн бұрын
Glad it was helpful!
Excellent, thanks Mynda. Very helpful especially for people still learning Excel.
@MyOnlineTrainingHub
4 ай бұрын
Cheers, Chris! Yes, definitely aimed at beginners. Appreciate you taking the time to watch still 😊🙏
Excellent Myanda, to help us work more efficiently.
@MyOnlineTrainingHub
Ай бұрын
Happy to hear that! 🙏
F4 repeats the last command for Word, Excel and PowerPoint Ctrl+d also duplicates if you have an object selected
@MyOnlineTrainingHub
4 ай бұрын
Yes, love F4 and CTRL+D. Thanks for sharing.
Ctrl+Shift+mouse wheel is amazing . Thank you.
@MyOnlineTrainingHub
4 ай бұрын
Great to hear!
I'm a subscriber and was sorry to hear about the security breach. You have educated the public how disruptive a breach can be to one's personal and professional life. Great to have you back.
@MyOnlineTrainingHub
4 ай бұрын
Thanks so much, Jason!
Simply the best. Very useful video for me as I use mac. Thank you.
@MyOnlineTrainingHub
4 ай бұрын
Great to hear!
I just came across your channel can't believe I am starting to understand Excel. Highly appreciated 🎉🎉🎉
@MyOnlineTrainingHub
4 ай бұрын
Wonderful to hear! Keep practicing. There's no Excel skills that aren't worthwhile 😉
Most of your videos put me in the ball park of "I wish I knew sooner" 😛
@MyOnlineTrainingHub
4 ай бұрын
Thanks for watching! Glad you learned something worthwhile 😉
Thank you For Your help..
@MyOnlineTrainingHub
4 ай бұрын
You're welcome!
Thank you, this is brilliant! Where were you 20 years ago?
@MyOnlineTrainingHub
4 ай бұрын
So pleased it was helpful 😊
How have I never known Ctrl+Alt+V???? Thank you!!
@MyOnlineTrainingHub
4 ай бұрын
😁 glad there was a nugget in there for you.
I use (and already knew) a lot of the tips you show in your video. But what I find a real time-saver as well sometimes is by using the QAT. I've put a lot of usefull commands in there e.g. Paste Values, Paste Formats, Clear Formats, Select visible cells, Paste formulas and many more. And easy to export those settings and import on another PC
@MyOnlineTrainingHub
3 ай бұрын
Great tip! Thanks for sharing, Frank. I love the QAT too 😁
Great video Ma'am I've learnt new shortcuts
@MyOnlineTrainingHub
3 ай бұрын
Great to hear!
Thanks; that’s handy. I’ve familiarized myself with Alt key combinations with home ribbons (Letters).
@MyOnlineTrainingHub
4 ай бұрын
Great idea!'
@SothearithKONGMrMuyKhmer
4 ай бұрын
@@MyOnlineTrainingHub Thanks so much for your comment! 🥰
Hi Mynda, Those are very helpful tips; there is a typo in Tip 23 @ 4:22 cmd+t and the same in Tip29 @ 5:12. This command is for a table but is incorrectly labelled for the Freeze pane. I am interested in knowing the shortcut, however. Thanks a lot!!
@MyOnlineTrainingHub
3 ай бұрын
Oops, sorry about that. It should be Command + Option + F.
So pretty and very smart.
I love shortcut keys it cuts down on the need to move your hand from the keyboard to the mouse also, unfortunately, I am old enough to remember using computers before the mouse was a standard feature, I still find myself going for the old alt key codes to get to the menus or rather ribbon these days!
@MyOnlineTrainingHub
4 ай бұрын
😁 I learned on Lotus 1-2-3 and back then it was all about the backslash!
@roywilson9580
4 ай бұрын
@@MyOnlineTrainingHub Lotus was a very good spreadsheet program. I think Excel copied over all the worst of Lotus and forgot about the best parts though 😢
@ndeeka
4 ай бұрын
Me too, although I also made my own personal ribbon for the functions I use most. But most users are probably not aware of that option, or they don't care. For me it saves plenty mouse movements (and therefore time) by itself to a level acceptable for me to use the mouse. Still, some short cuts are here too stay.
@roywilson9580
4 ай бұрын
@@ndeekaYes the ribbon has made it far easier to navigate to commands than the old way of doing it from the menu items where it might be three or four levels deep. I still find it quicker and less disturbing to my work flow to go for the keyboard shortcuts though.
Nice to see my beloved Alt+W FF. Another favorite of mine is Alt+D FF.
@MyOnlineTrainingHub
4 ай бұрын
Trying Alt+D FF now!
@ndeeka
4 ай бұрын
@@MyOnlineTrainingHub And, what do you think?
@Michael_Alaska
4 ай бұрын
@ndeeka I tried Alt+D,F,F, also Alt, D, F, F. Something pops up about Office Access Key but doesn't seem to do anything. What should we be seeing?
@MyOnlineTrainingHub
3 ай бұрын
@Michael_Alaska I'm not sure what that error is referring to. Try a Google search to see what others have found. @ndeeka nice, but I use Tables most of the time and they already have filters applied, so I'm likely to forget it for the rare occasions I need it 😂
@ndeeka
3 ай бұрын
@@Michael_Alaska it should apply Data filter. Weird you would get a popup. I assume you work in an English Excel environment.
Been a windows user all along and gonna switch to Mac soon.. Do you think, it is hard and time taking to adapt to the Excel in Mac ??
@MyOnlineTrainingHub
2 ай бұрын
Oh no! If you want to use Power Query to automate data cleaning and Power Pivot to analyse data, then forget the Mac. Or at least be prepared to install a virtual Windows machine with Parallels or similar so you can install Windows Excel.
F12 to save is a game changer!
@MyOnlineTrainingHub
4 ай бұрын
Glad you like it!
I love my control t with a cell selected in the range. And then it goes and just opens a new tab in Edge.
@MyOnlineTrainingHub
3 ай бұрын
Hmmm, that's odd. Sounds like Edge was the app in focus, not Excel. I've never seen Excel do that otherwise.
0:05 "I"m not going to cover them all in this video" Awwwww man :( You know we'd watch you talking about all 270 keyboard shortcuts!
👍👍👍👍 F12 - wow I didn't know that. The new save as is awful combined with OneDrive as only hard disk folders are offered and none of the quick access links I set up on Explorer are available. thankyou - Thankyou - THANKYOU Control-a is vastly underused. Likewise ctrl-r/d which can also be used on a single cell to copy the cell from the left / above. You undersell F4. It does not only do the ctrl-y job of un -un doing. It repeats an action as well. So a formatting action can be done on one cell, then another cell or range and yet another with F4.
@MyOnlineTrainingHub
3 ай бұрын
Glad F12 will be useful to you. Thanks for highlighting F4's extra functionality. 👍
I use ALT+number to quick access
@MyOnlineTrainingHub
4 ай бұрын
Yes, great tip! I always forget to use them 🤦♀️
Not sure if it's worth mentioning but I believe it's not actually ctrl + 0 and 9 to hide but ctrl + '(' and ')'.
@tiongah7690
4 ай бұрын
it is ctrl+0, if it is ctrl + ( then you would need to hit the shift key
@MyOnlineTrainingHub
4 ай бұрын
@Weehawk what @tiongah7690 said. Thank you both for watching 😉
CTRL+6 is hide shapes, graps, pictures. CTRL+W close the current workbook ALT+F4 close the excel CRTL+* select the corner cells of current region. SHFT+Space select the entire row CTRL+Space select the entire column CTRL+Page up shift the next sheet (CRTL+SHFT+3) CRTL+Page down shift the previous sheet (CRTL+SHFT+9) SHFT+F10 open the object pane SHFT+F8 open the random selection ALT+Down+Up Arrow Open the drop down list
@MyOnlineTrainingHub
4 ай бұрын
Ooh, there's some obscure ones there! Thanks for sharing.
@priyeshsanghvi8424
3 ай бұрын
@@MyOnlineTrainingHub another obscure but useful one > Ctrl + 8 to hide/unhide (toggle key) outlines used for grouping....useful for saving real estate on excel screen.....and Ctrl+Shift+F1 (toggle) for a fully excel-immersive view
Ctrl+Shift+L to add/remove a filter Ctrl+; to add today's date Windows+. to open smileys 👍←↑→↓△ Alt+ letter (quick access keys) for example Alt+E then G correspond to Ctrl+Alt+V Ctrl+Return to apply formula bar change to all selected cells Shift+ ←↑→↓ to add/remove rows/columns to a selection
@MyOnlineTrainingHub
4 ай бұрын
Thanks for sharing! I think I covered the last one 😉
@josh_excel
4 ай бұрын
Ctrl+Shift ; to add current time