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)
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 !
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
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 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!!
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!!
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.
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).
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.
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!
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!
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.
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
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 :)
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.
Here's a great one: add common actions to the Quick Access bar, and then each quick action can be accessed with Alt + [n]. For example, if you've saved Sort > Descending as your third quick action, pressing Alt + 3 will perform that step. This allows you to take the more convoluted/twisted shortcuts and reduce them to a very simple endeavor. Remember, unlike Ctrl and Shift, you do not need to hold Alt down, just tap it once; no more painful stretching!
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.
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.
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.
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.
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.
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!!
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.
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.
#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.
I also use: Alt+; to select only visible cells Ctrl+[ to select direct precedents. Then press F5 (or Ctrl+g) and Enter to go back F9 evaluate part of a formula Alt + DS for Sort Ctrl+_ (Ctrl+Shift+"-") to clear all borders Ctrl+Shift+` to apply general formating
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.
@@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!
F2 toggle in reference edits will change my life a little bit! Thank you! Ctrl-space selects colomn(s), shift-space selects row(s), ctrl-shift-space selects both, with ctrl-A behavior...
If your clipboard is in the ribbon then to Paste Special Values you can also use [Alt] - H - V - V. Alternatively if your keyboard has a "right-click" key then the easiest way to paste values is "right-click" key - V
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.
I just wanted to add there are many Alt key shortcuts that were available in excel 2003 still works in latest version one of that you already mentioned Alt ESV for value paste likewise Alt ORE row hight Alt OCW adjust column width Alt OHR sheet rename etc etc..
Just a note. I have 2 different keyboards. The Menu key is on the left for my newer Microsoft Natural keyboard, and on the right on my older Microsoft Natural keyboard.
Speaking of date and time shortcuts, one can insert the current date AND current time in 1 cell as a constant by typing CTRL + ; (semicolon) then SPACE then CTRL + : (colon)
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.
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 😉
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.
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.
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 :):):)
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 ...
Very interesting and useful video. But the shortcuts are only fully available if one has a QWERTY keyboard. I use an AZERTY keybord and a lot of them do not work properly. Do you have the alternative keyboard shortcuts for AZERTY keyboard? This would be very useful. Thank you.
In some countries in Europe (France, Belgium, Spain,...) AZERTY is the standard keyboard. You should search for it on Google (images). There you'll find examples of AZERTY keyboards. Some keys are placed completely elsewhere on an AZERTY keyboard regarding a QWERTY keyboard. On those AZ.... keyboard, some EXCEL and also WINDOWS keyboard shortcuts do work differently or not at all. Hope to have informed you a little bit about my and also many others problem.
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 ?
![[Live] : ONE 168 วันนี้!! "โจนาธาน vs ซุปเปอร์เล็ก"](http://i.ytimg.com/vi/0jIN65KgJsI/mqdefault.jpg)
![🎤 จับฉลากร้องเพลง x P’ #XXSIVK [EP.1] (2/2) เพื่อนจับได้คำไหน..ต้องร้องคำนั้น เริ่ม! 💓🎶 #MXFRUIT](http://i.ytimg.com/vi/1bJvMJXmeS4/mqdefault.jpg)
How many are from forage?
✋
🤚
@@december-sama4735 bhai course complete kiya?
@@nihalwaghmare3488 bhai course complete kiya?
I am from forage mam
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!
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 😁🙏
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 👍
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!!
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.
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!
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!
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
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 :-)
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!
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 :-)
Thanks for sharing your “secrets”, Mynda. Shortcuts makes more joyful when you work with excel...
You're very welcome, Vincent!
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 :-)
I´m a lover of shortcuts, and these are the best shortcuts I´ve never seen. Congratulations!
Wow, thanks! Glad you like them, Alejandro :-)
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!
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 :-)
Awesome blown my mind , guys do it on excel while watching simultaneously
So glad you like it! 🙏😊
For value pasting, I use Alt+H, V, V or Alt+H, V, F for formula pasting
Great to hear 😊
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. :-)
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.
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
Hey there
Just wanna say a thank you so much on these tutorial it really helped me ace my excel skills thank u so much
Great to hear!
Here's a great one: add common actions to the Quick Access bar, and then each quick action can be accessed with Alt + [n]. For example, if you've saved Sort > Descending as your third quick action, pressing Alt + 3 will perform that step. This allows you to take the more convoluted/twisted shortcuts and reduce them to a very simple endeavor. Remember, unlike Ctrl and Shift, you do not need to hold Alt down, just tap it once; no more painful stretching!
Great tip! Thanks for sharing 😊
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 :-)
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 :-)
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 :-)
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 :-)
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
Very good tips! The shortcut to check the formulas is amazing!
Great to know you found some you can use :-)
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 :-)
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!
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.
For pasting values I use Ctrl-V, Ctrl, v. So three distinct keyboard presses, but very easy to remember.
Thanks for sharing!
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 :-)
#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.
Thankk you for this full of knowledge video
It's my pleasure 🙏
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!
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 :-)
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 :-)
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!
I also use:
Alt+; to select only visible cells
Ctrl+[ to select direct precedents. Then press F5 (or Ctrl+g) and Enter to go back
F9 evaluate part of a formula
Alt + DS for Sort
Ctrl+_ (Ctrl+Shift+"-") to clear all borders
Ctrl+Shift+` to apply general formating
Thanks for sharing your shortcuts, Maxim! Some great ones there.
These are also my top shortcuts !
Please, note also CTRL + ; for today date
CTR + * for selecting the board
CTR + MAJ + L for filtering
Thanks for sharing, Jules!
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!
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!
Great tips! As always Mynda reminding us how to make excel and life easier!
Thank you Mynda!
My pleasure, Felipe :-)
F2 toggle in reference edits will change my life a little bit! Thank you!
Ctrl-space selects colomn(s), shift-space selects row(s), ctrl-shift-space selects both, with ctrl-A behavior...
Great to know you found a few shortcuts you can use, Stefano :-)
Excellent video. Only one I'd add is Ctrl ] to select dependent cells
Yes, great for debugging formulas. Thanks for sharing!
If your clipboard is in the ribbon then to Paste Special Values you can also use [Alt] - H - V - V.
Alternatively if your keyboard has a "right-click" key then the easiest way to paste values is "right-click" key - V
Thanks for sharing!
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 :-)
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.:)
I like the most Ctrl+1, did not knew it. I have also a tip: F12 in any Microsoft office means "Save as".
Thanks for sharing F12! I use that too.
I just wanted to add there are many Alt key shortcuts that were available in excel 2003 still works in latest version one of that you already mentioned Alt ESV for value paste likewise Alt ORE row hight Alt OCW adjust column width Alt OHR sheet rename etc etc..
Thanks for sharing! I use Alt ESV all the time too 😊
Just a note. I have 2 different keyboards. The Menu key is on the left for my newer Microsoft Natural keyboard, and on the right on my older Microsoft Natural keyboard.
Thanks for sharing, Carolyn!
Atl+a+c fastest way to clear filters. Great video. There were a couple new ones for me!
Thanks for sharing!
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!
This might be the most useful video ever uploaded to TH-cam
Wow, thank you!
it-was-excellent!
😁glad you enjoyed it!
Thanks for the video, actually learned several shorcuts I had no idea were available. Shorcut #8 did make my mind blow.
:-) great to hear.
Next level copy-pasting...You've more than earned my like and sub!
😁Thanks so much, Paul!
This was great! Thanks
Glad you enjoyed it!
Speaking of date and time shortcuts, one can insert the current date AND current time in 1 cell as a constant by typing CTRL + ; (semicolon) then SPACE then CTRL + : (colon)
Yes 👍thanks for sharing!
for paste special you can use Ctrl+alt+v then you can choose whatever paste special you want
Thanks for sharing, Haviz. I prever Alt > e > s > v as CTRL+ALT+V is awkward to press :-)
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.
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 😉
Thanks for sharing your secrets!
My pleasure!
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!
Not an Excel expert but pleased I knew most. ( not all). Like the ALT +
Glad you discovered some new tips you can use :-)
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 shortcuts, thank you so much! Wish I could press F4 and repeat the "thank you" 😊
:-D thanks so much!
Great Content
Thanks so much!
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!
List of shortcuts ! Good ! Your présentation makes it Wonderful ! Awesome...
Thanks so much! 😊
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 :-)
Loving the T-shirt 👕 , have a great time
Thanks so much!
Wow! great thanks - now only for me to remember them all!
Glad you liked it, Nisha!
We are grateful for these excel secrets! Thanks for the post👍
My pleasure 😊
Excellent tutorial of shotcuts. What a gift!!! Thank you Mynda!
Hope you discovered some new ones.
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!
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!
i cannot tell you how much this helps me.
Glad you can make use of the tips :-)
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 :-)
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.
Very Help full
Glad to hear that 😊
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!
i liked them all... i also use cntrl+0 to hide column
Pleased to hear that, Ayush!
Very interesting and useful video. But the shortcuts are only fully available if one has a QWERTY keyboard.
I use an AZERTY keybord and a lot of them do not work properly.
Do you have the alternative keyboard shortcuts for AZERTY keyboard? This would be very useful.
Thank you.
I've never heard of a AZERTY keyboard, sorry.
In some countries in Europe (France, Belgium, Spain,...) AZERTY is the standard keyboard.
You should search for it on Google (images). There you'll find examples of AZERTY keyboards.
Some keys are placed completely elsewhere on an AZERTY keyboard regarding a QWERTY keyboard.
On those AZ.... keyboard, some EXCEL and also WINDOWS keyboard shortcuts do work differently or not at all.
Hope to have informed you a little bit about my and also many others problem.
very helpful video!
Glad you think so!
Bass players can press CTRL+ALT+V no problem ;)
Great tips, thank you for this channel!
Where do I get that shirt????
😁 transferable skills! I think you can now get these shirts from Redbubble.
Ah spell check in excel! Fantastic
:-) glad you liked it, Liam!
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.
your so sweet to share all this thank you so much
You are most welcome!
Wicked smart! Work-Life balance saver!
:-D glad you liked it!
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.
the shortcut that had me doing aww was ctrl+; for the date
Glad you'll find it helpful 😊
Thank you!
You're welcome!
Paste Special: Alt, E, S was my eureka moment.
Great to hear 👍 in 365 you can now use CTRL + SHIFT + V for paste special 😉
Best excel video of 2020!!! thank you
Wow, thanks, Robert!