Excel Keyboard Shortcuts Pros Swear By to x10 PRODUCTIVITY

[@WordnWorld_]

How many are from forage?

[@december-sama4735]

✋

[@nihalwaghmare3488]

🤚

[@AniketSable-h7z]

@@december-sama4735 bhai course complete kiya?

[@AniketSable-h7z]

@@nihalwaghmare3488 bhai course complete kiya?

[@bhavyapriya-cd3cs]

I am from forage mam

[@avvabaldur]

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 !

[@MyOnlineTrainingHub]

So pleased to hear that it was worth your time to watch 😁🙏

[@Laurentmahe]

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)

[@MyOnlineTrainingHub]

Love those ones too, Laurent! Thanks for sharing :-)

[@ankursharma6157]

Noted, Laurent! Thank You!

[@rmmccarthy1240]

Thanks for the great tips, Laurent!

[@ankursharma6157]

I saw 1st Shortcut and I clicked on Like. For Me, it has been a big, big challenge. Gratitude!

[@MyOnlineTrainingHub]

So pleased you found some Excel keyboard shortcuts you can use, Ankur :-)

[@vincentlivera2948]

Thanks for sharing your “secrets”, Mynda. Shortcuts makes more joyful when you work with excel...

[@MyOnlineTrainingHub]

You're very welcome, Vincent!

[@tsalb96]

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.

[@MyOnlineTrainingHub]

Great to know you can make use of it :-)

[@aviman2010]

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

[@MyOnlineTrainingHub]

Thanks for your kind words, Tony! I'm delighted you're finding value in my videos.

[@JAAP2101]

I´m a lover of shortcuts, and these are the best shortcuts I´ve never seen. Congratulations!

[@MyOnlineTrainingHub]

Wow, thanks! Glad you like them, Alejandro :-)

[@Excelambda]

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.

[@MyOnlineTrainingHub]

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 :-)

[@Excelambda]

@@MyOnlineTrainingHub Ok, fair enough, then use right click and V, still faster, or 2 finger tap on a touchpad. :-)

[@mbrodd]

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

[@AlDunbar]

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.

[@MyOnlineTrainingHub]

Wow, that's awesome to hear!

[@suryavoid2488]

Awesome blown my mind , guys do it on excel while watching simultaneously

[@MyOnlineTrainingHub]

So glad you like it! 🙏😊

[@TSSC]

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

[@MyOnlineTrainingHub]

Nice, thanks for sharing!

[@rmmccarthy1240]

Fantastic! Thank you, TSSC!

[@NiteLynr]

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.

[@MyOnlineTrainingHub]

Thanks for your kind words! I'm so pleased it was worth your time to watch the video. :-)

[@IkaikaArnado]

Your excel knowledge is next level. Not only from this video but in from others I've seen.

[@MyOnlineTrainingHub]

Thank so much, Ikaika. Please share the videos with your co-workers :-)

[@IkaikaArnado]

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

[@Paladin101]

Definitely the arrows in the dialogue box!! So, soooo frustrating …. That one is life-changing for me ❤

[@MyOnlineTrainingHub]

So glad you can make use of that tip. It still trips me up sometimes, but at least I know how to fix it.

[@kimboard6720]

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]

Wow, glad you found some shortcuts you can use and thanks for sharing ALT > W > F > R :-)

[@digitalsurfer5458]

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!

[@MyOnlineTrainingHub]

Wow! Great to see you found so many new shortcuts you can use :-)

[@JonathanExcels]

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!

[@MyOnlineTrainingHub]

Thanks for sharing, Jonathan!

[@fajnefajne4339]

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.

[@MyOnlineTrainingHub]

Great to know you found some shortcuts you can use :-)

[@emilat_laccd630]

Yes, I used the F2 to edit cell, but didn't know about charts either

[@shivanshujain6074]

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

[@MyOnlineTrainingHub]

Great to hear!

[@giaizen]

Very good tips! The shortcut to check the formulas is amazing!

[@MyOnlineTrainingHub]

Great to know you found some you can use :-)

[@anitaarya5174]

For me #17 was new and awesome. Thanks for collating all and showing in 1 video

[@MyOnlineTrainingHub]

Glad you found a tip you can use, Anita!

[@williamharper9948]

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.

[@MyOnlineTrainingHub]

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 :-)

[@mwmstals]

Love the video, thought i knew them all but the F4 key to redo formatting was a nice surprise. Thanks!

[@MyOnlineTrainingHub]

Great to know you found something new you can use, Martjin.

[@emilat_laccd630]

Yes that's another favorite

[@spnhm34]

This might be the most useful video ever uploaded to KZbin

[@MyOnlineTrainingHub]

Wow, thank you!

[@Lifeslayer8]

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

[@MyOnlineTrainingHub]

😁 great to know you enjoyed it!

[@satindersingh8538]

Thanks a Bunch Mynda, Loved your Dashboards video and subscribed. God Bless for all your efforts in Educating the Excel Rookies.

[@MyOnlineTrainingHub]

Great to have you subscribe, Satinder :-)

[@mmcmillan1999]

Atl+a+c fastest way to clear filters. Great video. There were a couple new ones for me!

[@MyOnlineTrainingHub]

Thanks for sharing!

[@rohitrelwani]

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.

[@MyOnlineTrainingHub]

Glad you agree, Rohit :-)

[@NEHALENTERPRISES]

Very useful shortcuts and also very simple explanation.👌👌

[@MyOnlineTrainingHub]

Glad you liked it 🙏

[@brutusmorgan]

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!

[@MyOnlineTrainingHub]

I'm sure I'll be the same once I finally retire :-)

[@brutusmorgan]

@@MyOnlineTrainingHub Meanwhile, I wish you continued joy and good fortune before that time comes!

[@felipe4181]

Great tips! As always Mynda reminding us how to make excel and life easier! Thank you Mynda!

[@MyOnlineTrainingHub]

My pleasure, Felipe :-)

[@pipoclaude6771]

List of shortcuts ! Good ! Your présentation makes it Wonderful ! Awesome...

[@MyOnlineTrainingHub]

Thanks so much! 😊

[@olipeeeeee]

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.

[@MyOnlineTrainingHub]

Great to know you discovered some shortcuts you can use :-)

[@nguyenvu8262]

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.

[@MyOnlineTrainingHub]

Awesome to know you discovered a couple of new tips. Thanks for watching :-)

[@MohammadAshooryan]

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.

[@MyOnlineTrainingHub]

Thanks for sharing ALT+; :-)

[@MohammadAshooryan]

@@MyOnlineTrainingHub your welcome mynda.:)

[@khersheonteoh5697]

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.

[@MyOnlineTrainingHub]

Thanks for sharing, Kher :-)

[@Spacleaner5]

Ctrl+space and ctrl+shift to highlight a row or column. Blew my mind!

[@MyOnlineTrainingHub]

Awesome to know you found a couple of shortcuts you can use :-)

[@Adam_K_W]

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.

[@MyOnlineTrainingHub]

Thanks for sharing your Copy as Picture tip, Adam! I'll definitely be using that :-)

[@armanbahrami733]

Thank you for sharing such amazing shortcuts. For value paste I hold Alt then H , V , V.

[@MyOnlineTrainingHub]

You're welcome and thanks for sharing your paste values shortcut!

[@vinodhiliban]

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.

[@MyOnlineTrainingHub]

Awesome to hear you found it helpful, Vino :-)

[@vinodhiliban]

@@MyOnlineTrainingHub you are my favourite Excel Star.

[@sspan1]

For pasting values I use Ctrl-V, Ctrl, v. So three distinct keyboard presses, but very easy to remember.

[@MyOnlineTrainingHub]

Thanks for sharing!

[@naveedulhaq9542]

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

[@MyOnlineTrainingHub]

Thanks for sharing, Naveed! I'll definitely be using ALT > A > C :-)

[@naveedulhaq9542]

@@MyOnlineTrainingHub Glad to hear that 👍

[@PaulRichards1]

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.

[@MyOnlineTrainingHub]

Great idea, Paul!

[@emilat_laccd630]

Thank you ! That will save me some time

[@gandei100]

For value pasting, I use Alt+H, V, V or Alt+H, V, F for formula pasting

[@MyOnlineTrainingHub]

Great to hear 😊

[@markbrad123]

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.

[@MyOnlineTrainingHub]

So pleased you found some useful tips :-)

[@IvanCortinas_ES]

Excellent tutorial of shotcuts. What a gift!!! Thank you Mynda!

[@MyOnlineTrainingHub]

Hope you discovered some new ones.

[@vesaruusunen5685]

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

[@MyOnlineTrainingHub]

Yes, CTRL+G is super handy too.

[@pierreblanchard9752]

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.

[@MyOnlineTrainingHub]

Thanks, Pierre :-)

[@julessarkissian6147]

These are also my top shortcuts ! Please, note also CTRL + ; for today date CTR + * for selecting the board CTR + MAJ + L for filtering

[@MyOnlineTrainingHub]

Thanks for sharing, Jules!

[@paulkaddu5192]

Next level copy-pasting...You've more than earned my like and sub!

[@MyOnlineTrainingHub]

😁Thanks so much, Paul!

[@ivanov.max8]

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

[@MyOnlineTrainingHub]

Thanks for sharing your shortcuts, Maxim! Some great ones there.

[@leerv.]

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!

[@MyOnlineTrainingHub]

Great tip! Thanks for sharing 😊

[@rmmccarthy1240]

We are grateful for these excel secrets! Thanks for the post👍

[@MyOnlineTrainingHub]

My pleasure 😊

[@roizengh]

Thanks for the video, actually learned several shorcuts I had no idea were available. Shorcut #8 did make my mind blow.

[@MyOnlineTrainingHub]

:-) great to hear.

[@rhrmentor1367]

i really enjoyed these jumping short cuts at the beggining of this video.hahah. thanks for your time and sharing your skills with us....

[@MyOnlineTrainingHub]

Glad you like them :-)

[@rickkeev4919]

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]

Ooh, I like that one. Thanks for sharing, Rick!

[@darrylmorgan]

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 :):):)

[@MyOnlineTrainingHub]

Glad you found a tip you can use, Darryl :-)

[@danielzambori4364]

I like the most Ctrl+1, did not knew it. I have also a tip: F12 in any Microsoft office means "Save as".

[@MyOnlineTrainingHub]

Thanks for sharing F12! I use that too.

[@anithasreenivasan14]

i cannot tell you how much this helps me.

[@MyOnlineTrainingHub]

Glad you can make use of the tips :-)

[@יוכיתלם]

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.

[@MyOnlineTrainingHub]

Thanks for that!

[@colinburrows88]

Excellent video. Only one I'd add is Ctrl ] to select dependent cells

[@MyOnlineTrainingHub]

Yes, great for debugging formulas. Thanks for sharing!

[@clavendern]

Wow! great thanks - now only for me to remember them all!

[@MyOnlineTrainingHub]

Glad you liked it, Nisha!

[@EnchoDanielSamariya]

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

[@MyOnlineTrainingHub]

Great to hear!

[@captvo]

Great shortcuts, thank you so much! Wish I could press F4 and repeat the "thank you" 😊

[@MyOnlineTrainingHub]

:-D thanks so much!

[@guruprasadbm1987]

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.

[@MyOnlineTrainingHub]

You can't unlink a PivotTable, you'd have to copy and paste it as values and keep formatting.

[@theos1712]

Wicked smart! Work-Life balance saver!

[@MyOnlineTrainingHub]

:-D glad you liked it!

[@billmankin6204]

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!

[@MyOnlineTrainingHub]

😁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 😉

[@robbe58]

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.

[@MyOnlineTrainingHub]

I've never heard of a AZERTY keyboard, sorry.

[@robbe58]

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.

[@carolyngaither249]

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.

[@MyOnlineTrainingHub]

Thanks for sharing, Carolyn!

[@kunalchotalia5481]

Great Content

[@MyOnlineTrainingHub]

Thanks so much!

[@paulvanobberghen]

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)

[@MyOnlineTrainingHub]

Yes 👍thanks for sharing!

[@Caparzo_11]

Loving the T-shirt 👕 , have a great time

[@MyOnlineTrainingHub]

Thanks so much!

[@gobroin7307]

Not an Excel expert but pleased I knew most. ( not all). Like the ALT +

[@MyOnlineTrainingHub]

Glad you discovered some new tips you can use :-)

[@stefanogattoCH]

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

[@MyOnlineTrainingHub]

Great to know you found a few shortcuts you can use, Stefano :-)

[@muli3619]

My new favorites, F2 and ALT+=. I've learnt a lot more though. Thanks for this video.

[@MyOnlineTrainingHub]

Glad you can make use of the shortcuts, Muli :-)

[@irshadaranhikkal]

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

[@MyOnlineTrainingHub]

Thanks for sharing! I use Alt ESV all the time too 😊

[@virtualshift]

Thank you for these and all the hard work you put into your videos. They've been really helpful to me.

[@MyOnlineTrainingHub]

Happy to hear that!

[@michaeldavenport9268]

Thanks for sharing your secrets!

[@MyOnlineTrainingHub]

My pleasure!

[@RobertWelchman]

Best excel video of 2020!!! thank you

[@MyOnlineTrainingHub]

Wow, thanks, Robert!

[@gienniw4937]

Thank you!! Ctrl+’ for the formulas just blew my mind...

[@MyOnlineTrainingHub]

Great to hear!

[@gienniw4937]

MyOnlineTrainingHub thank you for all your videos. They are so clear and helpful, you are so talented!

[@ayushbhakre3407]

i liked them all... i also use cntrl+0 to hide column

[@MyOnlineTrainingHub]

Pleased to hear that, Ayush!

[@ngocquyfamily9646]

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

[@MyOnlineTrainingHub]

You can use Alt > O > C > U to unhide columns. It's not quite as elegant though.

[@dhanyakulkarni497]

it-was-excellent!

[@MyOnlineTrainingHub]

😁glad you enjoyed it!

[@rochrocks]

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

[@MyOnlineTrainingHub]

Thanks for sharing!

[@aggravated2008]

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.

[@MyOnlineTrainingHub]

Thanks for sharing :-)

[@ankursharma6157]

Hi, I tried to use Your recommended shortcut: Ctrl +. But, nothing happened. Request You to help Me understand the shortcut again.

[@emilat_laccd630]

yay, love the Ctrl + . Thanks!

[@ericlei2207]

This will save lifes lol Thank you for sharing!

[@MyOnlineTrainingHub]

Happy to help! 😁

[@johnborg5419]

Thanks Myndy. These were very helpful. :) :)

[@MyOnlineTrainingHub]

Great to know, John :-)

[@quishasalaskar7086]

your so sweet to share all this thank you so much

[@MyOnlineTrainingHub]

You are most welcome!

[@imranhamid1788]

Another excellent video.

[@MyOnlineTrainingHub]

Glad you enjoyed it, Imran!

[@johnnymac7395]

I love 'Alt + Enter' to repeat the last command you did.

[@MyOnlineTrainingHub]

Hey John, ALT+ENTER in edit mode inserts a carriage return/line break. F4 repeats the last command.

[@Mouyrf]

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 ?

[@MyOnlineTrainingHub]

Great to know you found some tips you can use :-) I suspect the regional settings are limiting the shortcuts for CTRL+backtick.

[@prasadshrivatsa6126]

Every time I learn a new Excel shortcut, I feel enlightened. These 20+ shortcuts are so useful. I especially liked #17. Thanks so much!

[@MyOnlineTrainingHub]

Great to hear, Prasad!

[@MohAboAbdo]

Thank you very much, dear teacher.

[@MyOnlineTrainingHub]

You're welcome!

[@rs991]

all shortcuts are awesome.. and I liked your 👕 t-shirt

[@MyOnlineTrainingHub]

:-) thanks, Rahul!

[@SergioAlejandroCampos]

Great thumbnail Mynda.

[@MyOnlineTrainingHub]

:-D lucky timing!

[@salpetrarca]

Bass players can press CTRL+ALT+V no problem ;) Great tips, thank you for this channel! Where do I get that shirt????

[@MyOnlineTrainingHub]

😁 transferable skills! I think you can now get these shirts from Redbubble.

[@CADineshsharma7]

Amazing tricks, thank you

[@MyOnlineTrainingHub]

Glad you found them helpful 🙏😊

[@RayanTech_ITSupport]

Interesting excel short cuts here

[@MyOnlineTrainingHub]

Glad you liked them!

[@RayanTech_ITSupport]

@@MyOnlineTrainingHub Makes excel cool having and knowing those short cuts

[@havizarga8457]

for paste special you can use Ctrl+alt+v then you can choose whatever paste special you want

[@MyOnlineTrainingHub]

Thanks for sharing, Haviz. I prever Alt > e > s > v as CTRL+ALT+V is awkward to press :-)