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)
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!!
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! 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!!
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.
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.
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!
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).
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!
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.
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
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.
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!
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
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!!
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!
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.
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.
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.
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.
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 :):):)
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.
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 😉
#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.
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...
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.
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.
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.
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.
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!
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.
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 :-)
Thanks for sharing your “secrets”, Mynda. Shortcuts makes more joyful when you work with excel...
You're very welcome, Vincent!
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! 🙏😊
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!!
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. :-)
This might be the most useful video ever uploaded to TH-cam
Wow, thank you!
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!
Very good tips! The shortcut to check the formulas is amazing!
Great to know you found some 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!
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 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 :-)
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.
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 :-)
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!
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
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
Very useful shortcuts and also very simple explanation.👌👌
Glad you liked it 🙏
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!
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!
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 :-)
Great tips! As always Mynda reminding us how to make excel and life easier!
Thank you Mynda!
My pleasure, Felipe :-)
We are grateful for these excel secrets! Thanks for the post👍
My pleasure 😊
Great Content
Thanks so much!
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!
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 👍
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!
Atl+a+c fastest way to clear filters. Great video. There were a couple new ones for me!
Thanks for sharing!
List of shortcuts ! Good ! Your présentation makes it Wonderful ! Awesome...
Thanks so much! 😊
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 :-)
Excellent tutorial of shotcuts. What a gift!!! Thank you Mynda!
Hope you discovered some new ones.
Wow! great thanks - now only for me to remember them all!
Glad you liked it, Nisha!
Next level copy-pasting...You've more than earned my like and sub!
😁Thanks so much, Paul!
Wicked smart! Work-Life balance saver!
:-D glad you liked it!
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 😊
i cannot tell you how much this helps me.
Glad you can make use of the tips :-)
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 value pasting, I use Alt+H, V, V or Alt+H, V, F for formula pasting
Great to hear 😊
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 :-)
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 :-)
Best excel video of 2020!!! thank you
Wow, thanks, Robert!
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 :-)
Loving the T-shirt 👕 , have a great time
Thanks so 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.
Awesome to hear you found it helpful, Vino :-)
@@MyOnlineTrainingHub you are my favourite Excel Star.
Thanks for sharing your secrets!
My pleasure!
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.:)
your so sweet to share all this thank you so much
You are most welcome!
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!
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!
Thanks Myndy. These were very helpful. :) :)
Great to know, John :-)
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
This will save lifes lol
Thank you for sharing!
Happy to help! 😁
Thank you very much, dear teacher.
You're welcome!
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 :-)
Amazing tricks, thank you
Glad you found them helpful 🙏😊
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 :-)
it-was-excellent!
😁glad you enjoyed 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.
Thanks for sharing, Kher :-)
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.
Another excellent video.
Glad you enjoyed it, Imran!
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 the video, actually learned several shorcuts I had no idea were available. Shorcut #8 did make my mind blow.
:-) great to hear.
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!
Thank you very much for the cool shortcuts
Glad you like them!
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!
Not an Excel expert but pleased I knew most. ( not all). Like the ALT +
Glad you discovered some new tips you can use :-)
all shortcuts are awesome.. and I liked your 👕 t-shirt
:-) thanks, Rahul!
For pasting values I use Ctrl-V, Ctrl, v. So three distinct keyboard presses, but very easy to remember.
Thanks for sharing!
Amazing video....very good work...keep up
Thank you, I will 😊
Thanks for sharing this valuable shortcuts
My pleasure, Saeed :-)
Cool very useful👍 thank you 🙏
My pleasure 😊
Great shortcuts, thank you so much! Wish I could press F4 and repeat the "thank you" 😊
:-D 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.
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 :-)
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!
Excellent video. Only one I'd add is Ctrl ] to select dependent cells
Yes, great for debugging formulas. Thanks for sharing!
Thank mam...you are awesome
.👏👏🙏
Interesting excel short cuts here
Glad you liked them!
@@MyOnlineTrainingHub Makes excel cool having and knowing those short cuts
Very helpful!
Glad you think so!
i liked them all... i also use cntrl+0 to hide column
Pleased to hear that, Ayush!
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 :-)
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!
very helpful video!
Glad you think so!
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.
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 :-)
Thanks for great & quickly skill !
My pleasure, Tery :-)
Ah spell check in excel! Fantastic
:-) glad you liked it, Liam!
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!
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.
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!
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!
Great video! Thanks
Glad you liked it, Terry :-)
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!