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,
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.
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!!
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
Monday, thank you again for another great video. I just purchased my first MacBook Air but have read the Excel doesn't have full functionality. Do you recommend purchasing a windows laptop instead? If anyone has recommendations please share.
😬sheesh! If you want to use Power Query to automate the gathering and cleaning of data, or Power Pivot to model and work with big data, then I'd definitely get a Windows laptop. The alternative is to install Parallels on the Mac and install Excel for Windows on there. Not sure how annoying this would be though.
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.
@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 😂
I am confused with showing absolute and relative references on a Mac your video says cmd+t but this brings up the dialogue box for creating a table. What am I doing wrong
The F4 equivalent on a Mac should be Cmd+t. However, the cell must be in edit mode, or you need to have your cursor in the formula bar for Cmd+t to toggle absolute references.
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 Lotus was a very good spreadsheet program. I think Excel copied over all the worst of Lotus and forgot about the best parts though 😢
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.
@@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.
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 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
👍👍👍👍 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.
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
❓Which Excel shortcut do you use the most?
FREE 239 Excel Shortcuts for Windows & Mac: bit.ly/shortcuts240225
ctrl a
ctrl c
ctrl v
ctrl t
Alt shift f3
what does it do@@LweisDeluna
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,
Oh yes, I forget you can do that too. Thanks for sharing 😊
F4 repeats the last command for Word, Excel and PowerPoint
Ctrl+d also duplicates if you have an object selected
Yes, love F4 and CTRL+D. Thanks for sharing.
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.
Thanks so much, Jason!
Great thanks Mynda very helpful especially for those who are learning Excil❤️❤️❤️❤️❤️
I'm glad you found it useful!
Excellent, thanks Mynda. Very helpful especially for people still learning Excel.
Cheers, Chris! Yes, definitely aimed at beginners. Appreciate you taking the time to watch still 😊🙏
I just came across your channel can't believe I am starting to understand Excel. Highly appreciated 🎉🎉🎉
Wonderful to hear! Keep practicing. There's no Excel skills that aren't worthwhile 😉
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!!
Oops, sorry about that. It should be Command + Option + F.
Thanks for these shortcuts (& the link). Your vids are really easy to follow and the video editing is great.
Awesome, thank 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
Great tip! Thanks for sharing, Frank. I love the QAT too 😁
Ctrl+Shift+mouse wheel is amazing . Thank you.
Great to hear!
This is exactly what I'm looking for! Thank you so much🥰
Glad it was helpful!
Excellent Myanda, to help us work more efficiently.
Happy to hear that! 🙏
Monday, thank you again for another great video. I just purchased my first MacBook Air but have read the Excel doesn't have full functionality. Do you recommend purchasing a windows laptop instead? If anyone has recommendations please share.
😬sheesh! If you want to use Power Query to automate the gathering and cleaning of data, or Power Pivot to model and work with big data, then I'd definitely get a Windows laptop. The alternative is to install Parallels on the Mac and install Excel for Windows on there. Not sure how annoying this would be though.
@@MyOnlineTrainingHub Thank you and apologies for addressing you as "Monday." Autocorrect:(
Thank you, this is brilliant! Where were you 20 years ago?
So pleased it was helpful 😊
Thanks so much for sharing. It's very useful and handy 🎉
Glad it was helpful!
Simply the best. Very useful video for me as I use mac. Thank you.
Great to hear!
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 ??
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.
Thanks; that’s handy. I’ve familiarized myself with Alt key combinations with home ribbons (Letters).
Great idea!'
@@MyOnlineTrainingHub Thanks so much for your comment! 🥰
How have I never known Ctrl+Alt+V???? Thank you!!
😁 glad there was a nugget in there for you.
Nice to see my beloved Alt+W FF. Another favorite of mine is Alt+D FF.
Trying Alt+D FF now!
@@MyOnlineTrainingHub And, what do you think?
@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?
@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 😂
@@Michael_Alaska it should apply Data filter. Weird you would get a popup. I assume you work in an English Excel environment.
Thank you For Your help..
You're welcome!
I am confused with showing absolute and relative references on a Mac your video says cmd+t but this brings up the dialogue box for creating a table. What am I doing wrong
The F4 equivalent on a Mac should be Cmd+t. However, the cell must be in edit mode, or you need to have your cursor in the formula bar for Cmd+t to toggle absolute references.
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!
😁 I learned on Lotus 1-2-3 and back then it was all about the backslash!
@@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 😢
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.
@@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.
Most of your videos put me in the ball park of "I wish I knew sooner" 😛
Thanks for watching! Glad you learned something worthwhile 😉
Great video Ma'am
I've learnt new shortcuts
Great to hear!
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
Ooh, there's some obscure ones there! Thanks for sharing.
@@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
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 to save is a game changer!
Glad you like it!
Not sure if it's worth mentioning but I believe it's not actually ctrl + 0 and 9 to hide but ctrl + '(' and ')'.
it is ctrl+0, if it is ctrl + ( then you would need to hit the shift key
@Weehawk what @tiongah7690 said. Thank you both for watching 😉
👍👍👍👍 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.
Glad F12 will be useful to you. Thanks for highlighting F4's extra functionality. 👍
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
Thanks for sharing! I think I covered the last one 😉
Ctrl+Shift ; to add current time
I use ALT+number to quick access
Yes, great tip! I always forget to use them 🤦♀️
I love my control t with a cell selected in the range. And then it goes and just opens a new tab in Edge.
Hmmm, that's odd. Sounds like Edge was the app in focus, not Excel. I've never seen Excel do that otherwise.
So pretty and very smart.
How to ALT +H+O+I in excel mac
Try the Option key instead of ALT.
Not helpful accept control c and z accept that we have to click and edit wasted my 5 minutes