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

[@MyOnlineTrainingHub]

❓Which Excel shortcut do you use the most? FREE 239 Excel Shortcuts for Windows & Mac: bit.ly/shortcuts240225

[@shakiraasfoor7599]

ctrl a ctrl c ctrl v ctrl t

[@user-jj1er3tu1h]

Alt shift f3

[@shakiraasfoor7599]

what does it do@@user-jj1er3tu1h

[@JimFikes]

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]

Oh yes, I forget you can do that too. Thanks for sharing 😊

[@elen_kulilili5048]

This is exactly what I'm looking for! Thank you so much🥰

[@MyOnlineTrainingHub]

Glad it was helpful!

[@learningwithmaliha]

Excellent Myanda, to help us work more efficiently.

[@MyOnlineTrainingHub]

Happy to hear that! 🙏

[@chrism9037]

Excellent, thanks Mynda. Very helpful especially for people still learning Excel.

[@MyOnlineTrainingHub]

Cheers, Chris! Yes, definitely aimed at beginners. Appreciate you taking the time to watch still 😊🙏

[@jasoncummings7052]

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]

Thanks so much, Jason!

[@user-ji3vy4yz4f]

I just came across your channel can't believe I am starting to understand Excel. Highly appreciated 🎉🎉🎉

[@MyOnlineTrainingHub]

Wonderful to hear! Keep practicing. There's no Excel skills that aren't worthwhile 😉

[@miall69]

Ctrl+Shift+mouse wheel is amazing . Thank you.

[@MyOnlineTrainingHub]

Great to hear!

[@whowhatwhenwhyhow9265]

Simply the best. Very useful video for me as I use mac. Thank you.

[@MyOnlineTrainingHub]

Great to hear!

[@tony586ful]

Thank you For Your help..

[@MyOnlineTrainingHub]

You're welcome!

[@josh_excel]

F4 repeats the last command for Word, Excel and PowerPoint Ctrl+d also duplicates if you have an object selected

[@MyOnlineTrainingHub]

Yes, love F4 and CTRL+D. Thanks for sharing.

[@IamTheReaper911]

Most of your videos put me in the ball park of "I wish I knew sooner" 😛

[@MyOnlineTrainingHub]

Thanks for watching! Glad you learned something worthwhile 😉

[@FrankLinssenPhotography]

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]

Great tip! Thanks for sharing, Frank. I love the QAT too 😁

[@Himanshu0719]

Great video Ma'am I've learnt new shortcuts

[@MyOnlineTrainingHub]

Great to hear!

[@yokoyama7590]

Thank you, this is brilliant! Where were you 20 years ago?

[@MyOnlineTrainingHub]

So pleased it was helpful 😊

[@SothearithKONGMrMuyKhmer]

Thanks; that’s handy. I’ve familiarized myself with Alt key combinations with home ribbons (Letters).

[@MyOnlineTrainingHub]

Great idea!'

[@SothearithKONGMrMuyKhmer]

@@MyOnlineTrainingHub Thanks so much for your comment! 🥰

[@wgalloPT]

So pretty and very smart.

[@jpparikh55]

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]

Oops, sorry about that. It should be Command + Option + F.

[@robhebert5137]

How have I never known Ctrl+Alt+V???? Thank you!!

[@MyOnlineTrainingHub]

😁 glad there was a nugget in there for you.

[@ndeeka]

Nice to see my beloved Alt+W FF. Another favorite of mine is Alt+D FF.

[@MyOnlineTrainingHub]

Trying Alt+D FF now!

[@ndeeka]

@@MyOnlineTrainingHub And, what do you think?

[@Michael_Alaska]

@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]

@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]

@@Michael_Alaska it should apply Data filter. Weird you would get a popup. I assume you work in an English Excel environment.

[@PraveenKumar-dt3lv]

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]

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.

[@lindsayl284]

F12 to save is a game changer!

[@MyOnlineTrainingHub]

Glad you like it!

[@antique-bs8bb]

👍👍👍👍 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]

Glad F12 will be useful to you. Thanks for highlighting F4's extra functionality. 👍

[@roywilson9580]

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]

😁 I learned on Lotus 1-2-3 and back then it was all about the backslash!

[@roywilson9580]

@@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]

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]

@@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.

[@vernacularbarnarchitecture]

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]

Hmmm, that's odd. Sounds like Edge was the app in focus, not Excel. I've never seen Excel do that otherwise.

[@missamo80]

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!

[@kuatle]

I use ALT+number to quick access

[@MyOnlineTrainingHub]

Yes, great tip! I always forget to use them 🤦‍♀️

[@Weehawk]

Not sure if it's worth mentioning but I believe it's not actually ctrl + 0 and 9 to hide but ctrl + '(' and ')'.

[@tiongah7690]

it is ctrl+0, if it is ctrl + ( then you would need to hit the shift key

[@MyOnlineTrainingHub]

@Weehawk what @tiongah7690 said. Thank you both for watching 😉

[@Tchernosplif]

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]

Thanks for sharing! I think I covered the last one 😉

[@josh_excel]

Ctrl+Shift ; to add current time

[@teoxengineer]

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]

Ooh, there's some obscure ones there! Thanks for sharing.

[@priyeshsanghvi8424]

@@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