101 Excel Shortcuts that will help to increase your Excel speed

Поділитися
Вставка
  • Опубліковано 13 жов 2024
  • In this Video you will Learn Almost all shortcuts of Excel I have picked based upon my regular used of excel these are the most useful 101 shortcuts of excel if you feel that there are some shortcut that i have missed then please add that shortcuts into comment box that will beneficial for others also. These excel shortcuts is almost working in all version of excel like : excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019.
    Attend Satish sir's Online Webinar Free: courses.skillc...
    #KeyboardShortcuts
    #ExcelShortcuts
    #ExcelTutorial
    To Read All Excel Shortcut keys Visit :
    learnmoreindia...
    Goto स्पेशल का वीडियो : • Excel Pro Tips to use ...
    पेस्ट स्पेशल का वीडियो : • Complete use of excel ...
    ३१ पावरफुल एक्सेल फार्मूला : • 31 Excel Powerful Form...
    ------------------------------------------------------------------------------------------------------------------------------
    Learn Satish Sir courses with Certificate
    Download Course App : bit.ly/3BWfQVa
    Courses Website :bit.ly/skill_c...
    Course Features :
    ✅ सभी Videos सरल हिंदी भाषा में
    ⬇️ Download Video in APP
    ✅ Basic to Advance Courses
    ✅ Practice Files (Yes)
    ✅ PDF Shortcuts
    ✅ Course Completion Certificate
    ✅ Instant Access
    ✅ Watch on Desktop : skillcourse.in/
    ------------------------------------------------------------------------------------------------------------------------------
    To download the practice file visit our telegram channel: telegram.me/le...
    Check our latest blogs: learnmoreindia...
    ------------------------------------------------------------------------------------------------------------------------------
    Social media Pages:
    Facebook Page Link: bit.ly/3CvGlBT
    Instagram Page Link: bit.ly/3f9R37u
    ------------------------------------------------------------------------------------------------------------------------------
    My Other Channels:
    Real Tutorial: ✅
    / @realtutorial550
    Complete Technology:✅
    / @completetechnology
    Learn more shorts:✅
    / @learnmoreshorts
    Satish Tech (Marathi):✅
    / @satish_tech
    Tally Tutorial:✅
    / @tallytutorial
    Exce Tutorial:✅
    / @excel_tutorial
    Learn More:✅
    / @learn_more
    Curiosity: ✅
    / @curiosity9432
    ------------------------------------------------------------------------------------------------------------------------------
    My UA-cam Gears :
    Best Mic for Recording (Condensor Mic): amzn.to/2UUMDnH
    Best Mic for Recording (Dynamic Mic ): amzn.to/3pQgyvD
    My DSLR Camera Canon 200D: amzn.to/39ciw3E
    My Laptop (Video Editing): amzn.to/2UXQj8h
    Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
    Antivirus: amzn.to/3l3TIgi
    Screen Recording Software: bit.ly/2J39n2j
    Video Editing Software: bit.ly/3nOPlri
    Green screen with Stand: amzn.to/2KAl1Cu
    Watch other Videos :
    Excel Basic to Advance Series : • Excel tutorial || Exce...
    Excel Amazing Features - • समय बचाना है तो सीखो य...
    Excel Advance 100 Videos - • Excel Introduction In ...
    Excel VBA Series in Hindi- • What is VBA in Excel? ...
    Excel MIS Videos - • ये सीखने के बाद एक्सेल...
    Word Series :
    • MS-Word Introduction |...
    PowerPoint Series : • सेमिनार, प्रेजेंटेशन, ...
    AUTOCAD SERIES : • ऑटोकैड सीरीज अब हिंदी ...
    Technology Videos - • Interview Preparation ...
    Computer Hardware in Hindi - • कंप्यूटर रिपेरिंग सीखन...
    Tags - Excel Shortcuts,Excel shortcut in Hindi,Excel shortcut keys in Hindi,Excel all shortcuts,Excel,Microsoft Excel Shortcut,Excel 2019 Shortcuts,Excel 2010 shortcuts,Excel 2013 shortcut,Excel 2016 Shortcut,Learn More, Satish Dhawale,Excel tutorial,Excel tutorial in Hindi, Excel tips in Hindi, Excel keyboard Shortcuts

КОМЕНТАРІ • 1,7 тис.

  • @Learn_More_Pro
    @Learn_More_Pro  2 роки тому +63

    Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/

  • @tanyakundansingh7758
    @tanyakundansingh7758 3 роки тому +11

    Mujhe nend aa rahi h fir bhi apki vdo dekh rhi hu bcz ap cmdy krte huye smjhate ho or bahut acche se samjhate ho thnk u so much bro...

  • @heaven9904
    @heaven9904 3 роки тому +8

    Sir, this video is very useful for excel learner. i starred to watch your video very recently. it will take time but i promise you to watch all video and become Excel expert. i am really thankful to you for making very essential video .thankyou very much and God bless you..

  • @MuhammadIsmail-sx8yv
    @MuhammadIsmail-sx8yv 2 роки тому +37

    For filter apply and remove also use CTRL+SHIFT+L

  • @AkmalKhan-by7xl
    @AkmalKhan-by7xl 3 роки тому

    اسلام و علیکم
    ستیش بھیا
    بہت خوب ، بہت زمانے سے Excel sheet میں کافی مشکلات ھو رھی تھیں.
    آپکی اس وڈیو میں میری بڑی مدد ملی ھے.
    آپکا بہت بہت شکریہ.
    اللہ پاک آپکو جزائے خیر عطا فرمائے
    شکریہ -
    محمد اکمل

  • @ahmerkhan2322
    @ahmerkhan2322 3 роки тому +8

    Learned many shortcut keys from it, thank you very much for sharing such a knowledgeable video.

  • @akashsaini9064
    @akashsaini9064 Рік тому

    Sir.....muje apki videos bahut pasand ayi maine in videos se 8din me poora excal with short key ke poora kiya h so bahut bahut danyabad sir apka

  • @dadasotaware662
    @dadasotaware662 4 роки тому +37

    OUTLOOK® SHORTCUT KEYS
    Alt + S Send the email
    Ctrl + C Copy selected text
    Ctrl + X Cut selected text
    Ctrl + P Open print dialog box
    Ctrl + K Complete name/email typed in address bar
    Ctrl + B Bold highlighted selection
    Ctrl + I Italicize highlighted selection
    Ctrl + U Underline highlighted selection
    Ctrl + R Reply to an email
    Ctrl + F Forward an email
    Ctrl + N Create a new email
    Ctrl + Shift + A Create a new appointment to your calendar
    Ctrl + Shift + O Open the outbox
    Ctrl + Shift + I Open the inbox
    Ctrl + Shift + K Add a new task
    Ctrl + Shift + C Create a new contact
    Ctrl + Shift+ J Create a new journal entry

  • @anilkumarlodhi4350
    @anilkumarlodhi4350 2 роки тому

    मैंने आप का वीडियो देखा और इसे देखते हुए मेरा एक शानदार अनुभव रहा सर मैंने बहुत कुछ नया सीखे आपका बहुत-बहुत आभार

  • @romagupta8166
    @romagupta8166 2 роки тому +6

    1:- ctrl+E flash fill
    2:- ctrl+pageup/ pagedown :- to jump on sheet
    Shift+arrow keys :- you can select
    4: - shift+space :- to select entire row

  • @brijesh8703
    @brijesh8703 3 роки тому

    U r doing good job sir.aapke jaisa koi tutor nhi Dekha aajtak Jo itni bariki se padata ho.thnku so much and Aapka Chanel world ke har jagah No1 ho

  • @arsalanmirza5103
    @arsalanmirza5103 4 роки тому +38

    I am from Pakistan.
    Great work sir , your students are very lucky if they have passion of learning excel.
    Please also upload uses of macros in different fields.

  • @himanshujonwal6580
    @himanshujonwal6580 Рік тому

    शानदार जानदार जबरदस्त 👍👍 thank u so much sir for all excel tricks

  • @ashking64
    @ashking64 2 роки тому +11

    3.Shift - right / down for selection for cells
    5. Ctrl + space for colum space
    7. Ctrl end last selection

  • @ajaykumar3919
    @ajaykumar3919 3 роки тому

    Sir you are the best teacher in the UA-cam apke jaisa koi nahi padhata

  • @saurabhsethi1942
    @saurabhsethi1942 4 роки тому +8

    its really useful video. I learnt lots of new formulas. I would like to tell you one more formula about "Filter". We can use formula Ctrl+Shift+L with this formula we can add or remove Filter from excel sheet.

  • @rajverma9b412
    @rajverma9b412 3 роки тому +1

    Thankyou sir your explanation is very good i watch all your video and now am felling good that i know to use computer all thing thank you sir may your channel be one of the biggest channel on youtube one day💯💯

  • @Marry3D
    @Marry3D Рік тому +6

    Ap ka har video achha hai

  • @saradaswain3136
    @saradaswain3136 3 роки тому

    Lajawaab hai aap ki collections. I amazed. Thank u so much. Aur. Bhi bahut kuch sikhna hai aapse.

  • @krishnakantmundra5388
    @krishnakantmundra5388 3 роки тому +5

    Appreciate your hard work and dedication. Superb content. 1 million sub soon😀

  • @meditations6679
    @meditations6679 3 роки тому +2

    There are lots of shortcut keys which were unknown for me. Thank you so much for giving most informatic knowledge. Hatsoff

  • @playfulimperfection
    @playfulimperfection 4 роки тому +17

    This Video deserves millions of views 🤗🤗

  • @nihalkhan8782
    @nihalkhan8782 2 роки тому

    Sir amazing 👍 aapki teaching best he mere brain me kaafi sara utar gaya and itne sare shortcut first time dekh ra hu sir

  • @Azhar_Khan383
    @Azhar_Khan383 4 роки тому +9

    excellent work & highly appreciated , Thanks Sir
    u can also use control+shift+L to apply & remove filter

  • @stereolifestyle2637
    @stereolifestyle2637 2 роки тому

    ALT > O > C > A TO ADJUST COLUMN ACCORDING TO TEXT

  • @SherSingh-vp7xl
    @SherSingh-vp7xl 4 роки тому +4

    Dear Sir, Row or column ko automatic adjust karna ka shortcut key bataye. Ya fir bina mouse ka row or column ka size kaisa adjust kare.
    Plz comment

    • @theviralindians3754
      @theviralindians3754 3 роки тому +1

      First select the data
      alt+o+c+a
      This will adjust automatically..

  • @aninditamishra8117
    @aninditamishra8117 2 роки тому

    Aap k teaching ka tarika bahut hi lazawab hai sir

  • @rahulshinde1591
    @rahulshinde1591 4 роки тому +18

    In excel older version, If we use Alt+Space Bar & C to close file then all open excel files get close so instead of that we should use ctl + W will close one by one. Sorry for bad english...🙏🙂

    • @talatmt187
      @talatmt187 2 роки тому

      Your English is not bad.it is alright

  • @shashikantanavkar3228
    @shashikantanavkar3228 2 роки тому

    एकदम मस्त आणि माहितीपूर्ण चित्रफीत धन्यवाद भाऊ

  • @ashwingowdillu2624
    @ashwingowdillu2624 4 роки тому +13

    Hi sir,
    Thanks & appreciate that u have provided all the shortcuts in single video. unfortunately I know every single shortcut u mentioned in this video...I'm looking short cut for
    1.working inside pivot table like selection of fileds
    2. Selection of objects (for example we have 30 object in a sheet. I need to select 15 or or 20 objects not necessarily in order)

  • @naseemahmed6759
    @naseemahmed6759 3 роки тому

    Shandaar Jandaar
    Jabardast
    jindabad
    Wah Satish Sir
    Kamal Kar Diye
    It's Very Useful For All Of Us

  • @jitendersingh9793
    @jitendersingh9793 4 роки тому +4

    Dear Sir,
    Complete shortcut keys in 1 video, very nice Sir 👍
    All in one Excel shortcut video.
    Colum unhide krne ka shortcut hai, Select two cell only for unhide colum- Alt+H+O+U+L very easy.
    Please add this shortcut key in next shortcut video.
    Kindly revert.

    • @Learn_More_Pro
      @Learn_More_Pro  4 роки тому +1

      yes yes jitender ji you are right thanks for sharing will definitely add it.

    • @jitendersingh9793
      @jitendersingh9793 4 роки тому +1

      @@Learn_More_Pro
      I'm your lover,
      Aapki video se mujhe bahut help hui hai.
      Apne office me Excel me faster ki trah kaam krta hun, Ye sab Aap se hi sikha hai.
      🙏🙏 Thank you Guru ji.

  • @sweetpuzzle2652
    @sweetpuzzle2652 2 роки тому +1

    Sir for me all shortcurt keys are new but i am hare for your shortcurt no.49&50 its really very help full for me thank you so much for your hard work and most important time as well as thank you 😊

  • @dadasotaware662
    @dadasotaware662 4 роки тому +5

    BASIC SHORTCUT KEYS
    Alt + F File menu options in current program
    Alt + E Edit options in current program
    F1 Universal help (for all programs)
    Ctrl + A Select all text
    Ctrl + X Cut selected item
    Shift + Del Cut selected item
    Ctrl + C Copy selected item
    Ctrl + Ins Copy selected item
    Ctrl + V Paste
    Shift + Ins Paste
    Home Go to beginning of current line
    Ctrl + Home Go to beginning of document
    End Go to end of current line
    Ctrl + End Go to end of document
    Shift + Home Highlight from current position to beginning of line
    Shift + End Highlight from current position to end of line
    Ctrl + f Move one word to the left at a time
    Ctrl + g Move one word to the right at a time

  • @pankajkumartanwar1157
    @pankajkumartanwar1157 3 роки тому

    Bhout badiya description sir

  • @rajeshsharma12925
    @rajeshsharma12925 2 роки тому +3

    In shortcut no 14(repeat last action), when I press F4, a pop up menu appears with the following options-PC screen only, duplicate, extend, second screen only etc.

  • @sagargaikwad7814
    @sagargaikwad7814 4 роки тому +1

    Dekha to sab kuch hain sir but bahut confused ho gaya hu .....but vapas ek ek vedio dekhenge to yad ana chalu ho jayega so thanks you sir

  • @jitendrakewat5771
    @jitendrakewat5771 3 роки тому +5

    I must appreciate your efforts to make ourself updated with technology.

  • @ganeshbhagat6628
    @ganeshbhagat6628 3 роки тому

    Sir Aapke Videos Bahot Aache Hai Sir Big Fan

  • @aadeshkumar2889
    @aadeshkumar2889 3 роки тому +8

    To Apply filter we can also use
    Carl+Shift +L

  • @aaftabsheikh7701
    @aaftabsheikh7701 Рік тому

    I watched full video without any skip and i got too much knowledge from this video
    Thank you so much sir and make more videos for the same.

  • @ADITYASINGH-vd9xh
    @ADITYASINGH-vd9xh 4 роки тому +11

    For filter
    Ctrl+shift+L

  • @tarunchaudhari5405
    @tarunchaudhari5405 2 роки тому +1

    jabardast teaching sir

  • @dipakdas2314
    @dipakdas2314 4 роки тому +7

    GREAT SIR FOR TEACHING PROCESS VERY INTERESTING

  • @researchbaba6921
    @researchbaba6921 2 роки тому

    कम समय में काम की चीज अच्छी तरह से समझा रहे हैं गुरुदेव आपका धन्यवाद में आपका सब्सक्राइबर हूं

  • @mohammadahmad8097
    @mohammadahmad8097 3 роки тому +5

    Please sometime teach how to do vertical selection in a split Excel column.

  • @chetansatyawali9726
    @chetansatyawali9726 Рік тому

    Sir आप की जानकारी बहुत सुंदर है 🙏👍
    एक एमआईएस रिपोर्ट कैसे बनाते हैं क्या क्या होता है please sir bata दीजिए 🙏🙏

  • @ajimali5259
    @ajimali5259 4 роки тому +6

    Nice video sir

  • @shafulkhan9595
    @shafulkhan9595 2 роки тому +1

    Or exal virsion me bhi yeh shortcut key kaam kr jayegi ya nhi sb me virsion same short key use ho sakti he bataiyega sir please

  • @dineshmathsclasses2514
    @dineshmathsclasses2514 3 роки тому +3

    Excellent explanation ,I can learn a lot from your channel, thank you so much for your time and effort.

  • @explore557
    @explore557 Рік тому

    Sir agr ap 1 request qubool krle? Ap Civil Enginnering k sarey softwares pe video kyu nhi bnate ? Sirf Autocad pe bnaye ha ..ap bnaye apka tareeka bht effective ha.Try kre hojaye ga .Plz Plz Plz

  • @rupeshgaikwad2472
    @rupeshgaikwad2472 4 роки тому +3

    to apply filter we can also use alt+ctrl+L

  • @marutistudio3255
    @marutistudio3255 3 роки тому +1

    I must appreciate your support and efforts it's very very helpful for me i think you are my guru in computer

  • @SarangManzoor
    @SarangManzoor 2 роки тому +5

    Ctrl + Shift + L for using filter key but make sure they are no merge columns/rows.

  • @bharatchz5112
    @bharatchz5112 2 роки тому +2

    Thanks you sir I has learnt many tricks from these video

  • @amruts6464
    @amruts6464 4 роки тому +16

    For Filter addition and deletion you can use. Cyrl+shift+L

  • @bhardwajkrishan2958
    @bhardwajkrishan2958 2 роки тому

    Sr, aap isko total short cut m use krke bataya kro Is say thoda aacha lagta h or humko remind hota h.

  • @karanbasnal9433
    @karanbasnal9433 4 роки тому +14

    Thank you so much to give me a wonderful short cut in excel
    I see your full video
    Best of luck for your channel

  • @satyadevpandey5458
    @satyadevpandey5458 4 роки тому +4

    1 No. Sir...

  • @niteshtayade2734
    @niteshtayade2734 2 роки тому

    Thanks you sir main ne aapse bohat kuchh sikha hai our ummid hain ki aage bhi skhta rahunga thank you so much

  • @priyankajaiswal9827
    @priyankajaiswal9827 3 роки тому +12

    FOR APPLY FILTER WE CAN USE CTRL+SHIFT+L

  • @vaibhavprabhuzantye8280
    @vaibhavprabhuzantye8280 10 місяців тому

    Very interesting and knowledgeable video!! Thank you, sir!!

  • @shridhart5340
    @shridhart5340 4 роки тому +3

    For Filter we can use Ctrl+Shift+L

  • @Vikash_Devrath
    @Vikash_Devrath 3 роки тому +1

    All is best video 👍❤️😎
    Thank you for excel shortcut key 🙏

  • @bijenderkumar7446
    @bijenderkumar7446 4 роки тому +5

    Hiii sir, I have to make a VBA for in/out stock inventory
    In which (in stock) date item qty Mfd Exp. Out stock date item qty given to and remains qty
    Plzz help me

  • @Akash-sz9em
    @Akash-sz9em 3 роки тому

    All your videos are very nice and give a lot of knowledge.

  • @cma.chander3719
    @cma.chander3719 4 роки тому +4

    Good job done 👍 GJD.

  • @ManojVerma-rg4ky
    @ManojVerma-rg4ky 2 роки тому

    i am from india
    sir, your excel work is a great ......
    sir your student is very lucky .....
    Thank you sir

  • @Rahulsingh-li3vx
    @Rahulsingh-li3vx 4 роки тому +15

    Alt+O+C+A also adjust column size

  • @rohitshirke1680
    @rohitshirke1680 10 місяців тому

    Nice to watch your video and lot of things I learnt from this video

  • @Rahulsingh-li3vx
    @Rahulsingh-li3vx 4 роки тому +6

    Short cut key for protect sheet
    1st Alt+R+P+S
    2ND ALT+H+O+P

  • @vanijha4117
    @vanijha4117 3 роки тому +1

    I had also learnt more about computer only by the help of you, because of ur explanation very nicely. Thank you.

  • @chhotudesigners3889
    @chhotudesigners3889 4 роки тому +4

    Starting Sir learning Excel 🙏🙏🙏

  • @MuhammadKamran-cq4ro
    @MuhammadKamran-cq4ro 3 роки тому

    I am beginner, learning from your videos well

  • @Rahulsingh-li3vx
    @Rahulsingh-li3vx 4 роки тому +6

    Short cut key for filter apply
    Ctrl + shift +L

  • @islamicworld3031
    @islamicworld3031 3 роки тому

    Yes jazak Allah khair

  • @dharmpalsingh5267
    @dharmpalsingh5267 4 роки тому +30

    Where are u coching/ institute. I Learn advance excel for you.

  • @makeshn9813
    @makeshn9813 2 роки тому

    Wowwww Master ji. Very interesting. Especially your way of expression in the smiling method, no one would forget the shortcut keys.

  • @sauravvlog2123
    @sauravvlog2123 5 місяців тому +20

    kon kon 2024 m dekh rha h

    • @nirajsk8226
      @nirajsk8226 14 днів тому +1

      Tujhe kya karna hai bhai koi bhi dekhe 🤦🏻‍♂️🤦🏻‍♂️🤦🏻‍♂️

  • @kartikmishra5560
    @kartikmishra5560 2 роки тому

    Thankyou so much. Some of the features i didn't know even after working in excel for a long time.

  • @rishabhsinghrajput1706
    @rishabhsinghrajput1706 3 роки тому +5

    Work book doesn't gets closed by CTRL +F4. IT GETS BY PRESSING Alt +f4

  • @aanandsingh6701
    @aanandsingh6701 4 роки тому

    Thanks sir itna achcha video banane ke leye

  • @vipulvirle2577
    @vipulvirle2577 4 роки тому +28

    Alt+D+F+F simple filter shortcut key

  • @storelinedad8830
    @storelinedad8830 3 роки тому

    thanku sir
    apke shikhane ka tarika bahut mast hai

  • @durgeshdohare7083
    @durgeshdohare7083 4 роки тому +9

    shandar sir.....😊

  • @ababilpeekflying
    @ababilpeekflying 2 місяці тому

    Hello sir you are a great person & teacher ❤. Thank you so much sir.
    God bless you 🤲❤

  • @rashiaggarwal4468
    @rashiaggarwal4468 2 роки тому +1

    Sir you are best. Thanks for this informative video 🙏☺️

  • @sureshsah9680
    @sureshsah9680 4 роки тому +6

    Press "Alt+=" to auto sum..

  • @nitishsingh1998
    @nitishsingh1998 Рік тому

    I am a beginer in excel try to learn from your videos now thanks sir

  • @indigo_rash1122
    @indigo_rash1122 4 роки тому +9

    I have noticed no matter how much I learn, I am extremely slow at analysing data of any kind :(

  • @Piyush-f2j
    @Piyush-f2j Рік тому

    Excellent Work and Phenomenal Presentation; Hatsoff

  • @A1badalvlog
    @A1badalvlog 4 роки тому +5

    Jisko bhi video achha laga like karo

  • @subashchander9137
    @subashchander9137 3 роки тому

    Thanks for 101 shortcuts dear brother

  • @mr.arabindakumar7162
    @mr.arabindakumar7162 4 роки тому +7

    Nice jokes

  • @KiranmoySarkar-l4c
    @KiranmoySarkar-l4c 2 роки тому

    Sir mujhe apki intin gyan se bohot help ho raha hay

  • @nasiraziz9195
    @nasiraziz9195 Рік тому +3

    karachi pakistan

  • @khushboochaurasiya4569
    @khushboochaurasiya4569 3 роки тому

    AND ALL THE SHORTCUT KEYS ARE REALLYVERY AMAZING

  • @vipulvirle2577
    @vipulvirle2577 4 роки тому +4

    Alt+O+C+A Column auto fit

  • @AkshayKumar-mt6lh
    @AkshayKumar-mt6lh Рік тому

    Thank you sir😄 shortcut key aapne bahat achchha se samjha rahe hai koi koi shortcut pata tha aur aapne bata diya thank you so mach sir

  • @singh6737
    @singh6737 3 роки тому

    I didn't know how to find in complete workbook. Your method to explain the things is so good.