5 Awesome Excel Keyboard and Mouse Tricks

[@junaopako]

Thanks man, you're a doctor for Excel

[@trumpexcel]

Thanks for the kind words... Glad you liked the video!

[@michelbaudoinca]

Thank you Very much Sumit ! Always helpfull !

[@pari4453]

I'm glad i saw your video this is excellent, great work sumit luv the way you explain

[@priyanthiabayasekara8819]

Thanks for sharing these tips. much appreciated.

[@sinhalafilmsub308]

Hi If you want to know about Excel macro and customized functions, contact me "[e-mail]"

[@andrewshepherd6816]

Well explained 👍 You certainly get to the point without any unnecessary waffle 🙂 Cheers

[@VinodKRamachandra]

Cool little tricks. Thank you Sumit

[@trumpexcel]

Glad you found the video useful Vinod!

[@SnipSnapDragon24]

Your videos are always wonderful and very much appreciated. Thank you.

[@trumpexcel]

Thanks Chris... Glad you're finding the videos useful!

[@keithau8159]

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,except my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got na.Bar kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bo ho men sai ha hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung kar.Bar hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar mei link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha hei.Bo ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot temple.No wonder draw tourists come to Holly Khilasa temple to vist at all@@@@@Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all.Google ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century@@@@@

[@kamlabimla]

Thanks Sumit!! Keep it up

[@trumpexcel]

Glad you liked the video Swati!

[@deepaknagar5697]

Your videos are always awesome, thanks.

[@karthikrajgopal8627]

Thanks very informative video..

[@gauravbhasin757]

Awesome man

[@anusree1611]

Very good tips. Grateful

[@woutervandenheever8999]

Very good! Thanks.

[@indrapahlefi828]

Thank you Summit...

[@tsvs58]

Very useful and interesting. Thanks

[@rajeevgosavi4514]

I always appreciate your videos on various topics, as they are easy to understand. You have a unique way of explaining.Can I request you to upload a video on tab control techniques.

[@reshmasaldanha5087]

Excellent. I have recently subscribed your you tube channel & it's really helpful. A big thank you. You are a wonderful teacher.

[@mdexcelpro8495]

Excellent and very helpfull & useful tips thanks of lots

[@vaishalipathak7863]

All the tricks you share are very much useful and increases efficiency to a big extent. Thanks for sharing!

[@krishnamurthyramanathan1795]

Thanks

[@monicacato999]

Great tips !

[@ashubedi4078]

You really have indeed awesome knowledge

[@emmaleeholzheimer5118]

Thanks, I learn so much with your excel training.

[@tarawalters815]

THANK YOU!

[@afruitaday]

These tricks are great. You nailed it Mr. Sumit Bansal

[@sguptamech]

Super tips

[@johnborg5419]

Thanks Sumit. This helps alot!!! : )

[@bycottfrenchproducts.mukht1189]

Great, thanks.

[@sekhar6106]

Thank you. Will practice this to be familiar with the tricks...

[@samuelmeende2325]

Thanks man

[@murtazasimari8850]

Bless you...nice video

[@mhammad3492]

Thank you 🌹

[@ramseshu110]

Excellent 👍

[@nidhiachhaa2731]

Wonderful tips💡

[@deepikagaddam5764]

Seriously you are awesome

[@meshafeeqmuhammed983]

Wow... Really help full Excell Guru

[@Rahulkumar-he4sk]

Thank you, Sir very informative video

[@rjbanavar]

Deselect the Cells and Copy of the Sheets with (Year) / (Q1) is awesome trick, Thanks a lot helps big time

[@vishalsheth506]

Amazing tricks...Didn't know about this...

[@wayneedmondson1065]

Hi Sumit.. truly said.. all the tricks you showed are awesome! I knew a few and learned a few new ones :)) Thanks for sharing and Thumbs up!!

[@MareeTeolanafo]

Another informative video. I love all of them!

[@basis_tech4555]

Thanks for sharing..really very useful in day to day tasks on excel

[@sinhalafilmsub308]

Thank you very much!!

[@BARATHICREATIVES]

Thanks... very useful

[@meetkcs]

Sumit is Excelled in Excel Excellently. Awesome shortcut key combinations, Very productive in Real-time application.

[@mahansor8295]

Thanks, great

[@Ff13jap]

Awsome! 👍👍

[@storytime5108]

Thanks Sumit

[@KaileshHambireIJ-G-]

Thank you very much for this update. Keep updating us with your valuable knowlege.

[@shahulhameed-dc2fz]

Excellent

[@FaysalEasyExcel]

Thanks. it's really awesome.

[@JahangirAlam-zz9ex]

nice and excellent

[@trumpexcel]

Glad you found the video useful!

[@mdsajji6290]

It's really cool and mind blowing tricks Bro. Appreciated.

[@keithau8159]

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got na.Bar kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bo ho men sai ha hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung kar.Bar hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar mei link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha hei.Bo ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot temple.No wonder draw tourists come to Holly Khilasa temple to vist at all@@@@@Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all.Google ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century@@@@@

[@amralkady6929]

Thanks 👏👏 alot

[@shubhamgupta4U]

Awesome tricks

[@reechatimilsina5640]

thank you sir

[@hazemali382]

great♥

[@dudukusudhakar2903]

very useful tricks

[@HusseinKorish]

Amazing

[@maheshpatidar6807]

Really awesome video, thank you sir, is there any way to copy any sheet to another new workbook kindly help

[@caaman93]

Good one

[@mboush123]

Great

[@akji2113]

I love your english sumit

[@yogeshchandrabhatt227]

Thanks to trumpexcel for the easy and free access excel content to all ! Would like to know if you starting Dax Course. I have been trying to get % contribution of product YOY with Dax measure ans want to draw chart over that contribution. But stuck !

[@rabdu2002]

Dear Sumit, thanks for the information you shared, but could you please tell us what is the benefit of the trick no 5 since i can't copy the selected columns or rows.

[@MS-em4bf]

“06:36” shift + ctrl + ‘+’

[@planxlsm]

00:00​ Intro 00:15​ Quickly Move Rows and Columns in Excel 02:18​ Quickly Copy Rows and Columns in Excel 03:29​ Copy Worksheets 05:39​ Insert Rows/Columns in Existing Dataset 06:42​ Deselect Cells

[@vaishuvenkats9959]

Hi can you make ms outlook series same like ms excel series your all excel video awesome... Please kindly making ms outlook series.. Wait for u...

[@caprashantkhandelwal558]

good

[@mcbasak]

Thanks Sumit for this useful tips. I have a question. Suppose I have a sheet named 'Jan-2020'. Now I like to create 11 new sheets for all the rest of the months of the year 2020. Is there any shortcut way?

[@georgywordrighter5662]

Excellent as ever - No 1 fan- However - I have to use an online shared excel sheet and these commands don't work: for example I cannot copy only visible cells (for which you provide instruction using alt ;) nor (oddly) can I create a running sequence by dragging down the first few if I have the columns filtered. It simply copies the first one (eg 123,highlighted and dragged gives 1 1 1 in the target cells) It also doesn't allow me to count how many visible rows - is this an issue with the online Excel I am forced to use for collborative reasons or me?

[@gabriellakecskes6305]

Where is the spreadsheet that goes with this video please?

[@hariomgupta4677]

Sir i make a filter vba but my vba code show some errors. I try to solve error but my vba errors not solve can u please solve my vba error and how can i send my error vba file please help 🙏🙏🙏🙏🙏🙏

[@fayazmuhammad5983]

Sir please upload 2 to 3 videos per week 1 video is not sufficient in a week

[@trumpexcel]

Thanks for the feedback Fayaz.. I am planning to increase the frequency to 2 videos per week. Hopefully soon!

[@ayubtonshyal]

I'm master in Excel, but I wasn't know the tip 1 & 2...

[@AmitSharma-zp5cd]

Hi sumit, I have send u an excel on your mail, need to take some guidence . I dont have your no. And I tried to contact at your postal address but no response recieved

[@Its.my.pleasure]

Bro, u r talking in English, then why r u pushing that dam English subtitles

[@trumpexcel]

Subtitles are meant for people who may have difficulty in hearing as well as for those who are not able to follow English easily. You can turn if off with a click if you want. A little empathy goes a long way

[@masudbin-arazzaque4295]

Very useful trick