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 !
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)
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 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
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.
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!!
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!!
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).
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!
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.
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
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!
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 :)
@@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!
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 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 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.
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!
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.
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.
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
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.
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!!
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.
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.
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.
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...
#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.
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)
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.
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
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.
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.
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.
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 :):):)
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 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.
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 ?
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 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 ...
How many are from forage?
✋
🤚
@@december-sama4735 bhai course complete kiya?
@@nihalwaghmare3488 bhai course complete kiya?
I am from forage mam
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 😁🙏
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!
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 :-)
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 👍
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!
Thanks for sharing your “secrets”, Mynda. Shortcuts makes more joyful when you work with excel...
You're very welcome, Vincent!
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 :-)
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.
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
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!!
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!
I´m a lover of shortcuts, and these are the best shortcuts I´ve never seen. Congratulations!
Wow, thanks! Glad you like them, Alejandro :-)
Awesome blown my mind , guys do it on excel while watching simultaneously
So glad you like 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 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. :-)
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!
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.
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 :-)
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 :-)
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!
Very good tips! The shortcut to check the formulas is amazing!
Great to know you found some you can use :-)
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
This might be the most useful video ever uploaded to UA-cam
Wow, thank you!
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 :-)
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 :-)
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!
Great tips! As always Mynda reminding us how to make excel and life easier!
Thank you Mynda!
My pleasure, Felipe :-)
For value pasting, I use Alt+H, V, V or Alt+H, V, F for formula pasting
Great to hear 😊
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 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 :-)
Atl+a+c fastest way to clear filters. Great video. There were a couple new ones for me!
Thanks for sharing!
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 😊
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 :-)
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 :-)
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 :-)
Very useful shortcuts and also very simple explanation.👌👌
Glad you liked it 🙏
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.
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 :-)
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!
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
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 :-)
We are grateful for these excel secrets! Thanks for the post👍
My pleasure 😊
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.
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!
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.:)
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!
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!
For pasting values I use Ctrl-V, Ctrl, v. So three distinct keyboard presses, but very easy to remember.
Thanks for sharing!
Great Content
Thanks so much!
Excellent tutorial of shotcuts. What a gift!!! Thank you Mynda!
Hope you discovered some new ones.
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!
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 :-)
Thanks for the video, actually learned several shorcuts I had no idea were available. Shorcut #8 did make my mind blow.
:-) great to hear.
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 :-)
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.
List of shortcuts ! Good ! Your présentation makes it Wonderful ! Awesome...
Thanks so much! 😊
#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.
i cannot tell you how much this helps me.
Glad you can make use of the tips :-)
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!
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 😊
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 :-)
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!
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!
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!
Excellent video. Only one I'd add is Ctrl ] to select dependent cells
Yes, great for debugging formulas. Thanks for sharing!
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!
Wow! great thanks - now only for me to remember them all!
Glad you liked it, Nisha!
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.
Great shortcuts, thank you so much! Wish I could press F4 and repeat the "thank you" 😊
:-D thanks so much!
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!
Next level copy-pasting...You've more than earned my like and sub!
😁Thanks so much, Paul!
Not an Excel expert but pleased I knew most. ( not all). Like the ALT +
Glad you discovered some new tips you can use :-)
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 :-)
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 :-)
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 😉
i liked them all... i also use cntrl+0 to hide column
Pleased to hear that, Ayush!
Best excel video of 2020!!! thank you
Wow, thanks, Robert!
Thankk you for this full of knowledge video
It's my pleasure 🙏
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 :-)
Wicked smart! Work-Life balance saver!
:-D glad you liked it!
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.
your so sweet to share all this thank you so much
You are most welcome!
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!
Thank you!! Ctrl+’ for the formulas just blew my mind...
Great to hear!
MyOnlineTrainingHub thank you for all your videos. They are so clear and helpful, you are so talented!
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!
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.
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.
Loving the T-shirt 👕 , have a great time
Thanks so much!
it-was-excellent!
😁glad you enjoyed it!
Thanks for sharing your secrets!
My pleasure!
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!
This was great! Thanks
Glad you enjoyed it!
Thanks Myndy. These were very helpful. :) :)
Great to know, John :-)
Thank you very much, dear teacher.
You're welcome!
Thank you very much for the cool shortcuts
Glad you like them!
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.
This will save lifes lol
Thank you for sharing!
Happy to help! 😁
Another excellent video.
Glad you enjoyed it, Imran!
all shortcuts are awesome.. and I liked your 👕 t-shirt
:-) thanks, Rahul!