Most important Keyboard Shortcuts in Excel - Malayalam Tutorial

Поділитися
Вставка
  • Опубліковано 17 гру 2024

КОМЕНТАРІ • 351

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

    Thank you so much for such a video. I just gone through your channel all the videos are very useful and well explained. Expecting a video for advanced level pivot table..... Once again thank you......

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

    Daily use cheyyan ullath correct kitty Thanks sir 🙏

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

    Extremely useful video.
    Looking forward to more such educational videos.
    Thank you and best wishes.

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

    For Filter Alt+D+F+F and Paste special alt+ctrl+v also can use

  • @ManojKumar-pv7ng
    @ManojKumar-pv7ng 4 роки тому +7

    Excel class very useful and interesting, please give more functions, formula based and text base class

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

      Please xheck the Playlists section for more videos. Playlist of 50+ functions are given below.
      ua-cam.com/video/sh4IKt5Wi5U/v-deo.html

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

    You are really stupendous!!! Appreciate for your great efforts Sir👏👏👏👏👌👌👌👌👌👍👍👍👍🙏🙏🙏🙏🙏✌

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

    25 th can be done using control+alt+v
    To copy the content frome the above cell to the down cell control+d also can be used

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

      Thank you for sharing the Tip!😀

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

      @@XLnCADMalayalam The content from left sell to right sell/ CTRL+r

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

    Alt+ Enter key ( long time finding this options)👍👍

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

    വളരെ നല്ല അവതരണം, very very informative

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

    ഒരുപാട് ഒരുപാട് ഒരുപാട് ഉപകാരം ചേട്ടാ..... താങ്ക്യൂ സോ മച്ച്...... 🥰👍🏻

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

    Thanks for another good information 👍🏻👍🏻👍🏻

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

    Very useful and informative. Thanks

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

    Very helpful short cuts... 👍👍👍 thanks bro....

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

    Very useful video🌹simple presentation...

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

    Very useful very nice we hope more videos frm your side

  • @Hari-n4f
    @Hari-n4f 3 роки тому +2

    You are Dr Ajay Anand or Prof Ajay Anand. I feel knowing nothing about Excel the more I listen to you. Thanks a lot.

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

    Thanks .It is very good presentation .

  • @sankaranarayanan7773
    @sankaranarayanan7773 3 роки тому +10

    As always great lessons in a very professional manner.keep it up sir

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

    Finally found the perfect video 😭❤..Thank you sir 🙌🏻

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

    Appreciate and thank you so much Sir 👍🙏 for the valuable information 👌

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

      Glad to hear that. There is one more video on Excel shortcuts. I recommend to refer that too.

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

      @@XLnCADMalayalam thanks and noted Sir 👍🙏

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

    Useful video..thnku.. thnku so much sir🙏

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

    you reveal a magic world in XL. Very useful..

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

    Very good method
    Thank u very much

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

    Very useful tips tips, can I get this short cuts in excel as you show in video 0:19 please

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

    Very useful video 👌 thank you sir

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

      It's my pleasure and thank you for your kind words.

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

    Useful episode, thank you 😊 Appreciate

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

    Super very helpful appreciate your effort

  • @മഹാകവിഅർജുനൻ-വ1യ

    Sir, very usefull video, thnq💓

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

    Sir , well presentation. Its very easy to understand. And we can use alt+ctrl+v shortcut key for paste as value instead of Alt+E+S+V.

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

    I must say. Realy nice. One doubt how visible again hidden rows or hidden column

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

      Glad to hear that.
      Click on the small Triangle in the Top left corner of the worksheet to select the Entire sheet > Right-click on any Column header (A, B, C etc.) and select Unhide. Every hidden column will become visible.
      To unhide Rows, Select the entire sheet, Right-click on any Row header (1, 2, 3 etc.) and select Unhide.

    • @shabanashaji3937
      @shabanashaji3937 4 роки тому +2

      @@XLnCADMalayalam thank u so much for ur concern

    • @DigitalPedagogykvm
      @DigitalPedagogykvm 4 роки тому +2

      How to change case as Capitalise Each Word (First letter of all words in a sentence) ?

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

    Sir njn examinte Annu morning aanu ee video kande Enikku upakaarapettu Thak you sir😍😍😍😍😍

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

    Very good presentation.

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

    🌟🤩 Ithilum nannayi vere aar paranj tharum... 🌟

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

    Splendid Presentation👍

  • @mariafulgen9644
    @mariafulgen9644 6 місяців тому +2

    Very simple n excellent

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

    Nice way of presentation 🤝

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

    Excel SHORTCUTS explained excellently

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

    Please let me know that,Is ther anyway to directly copy a file description(eg.Title,Date) and paste it to excel. Thank you.

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

      Please refer my video on 'How to create list of files in a folder'

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

    Very informative..

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

    XL n CAD ന്റെ WORD Help videos ഉണ്ടോ

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

    Excellent instruction, thanks.

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

    Thangalude video kandanu njan padikunnath,thnk u

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

    Thank u sir you're my teacher

  • @joepaul10
    @joepaul10 3 роки тому +6

    ഒരു excel ഷീറ്റിലേക്ക് ഉള്ള ലിങ്ക് track ചെയ്യാൻ ഏത് കീ കോമ്പോ ആണ് ഉപയോഗിക്കേണ്ടത്

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

    Really useful.... Thank you..

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

      My pleasure. I have one more video on Excel shortcuts for beginners. Check that too.

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

    Super video very helpful✌️

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

    Thank you sir, good class

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

    Good class... Thanks

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

    Thanku sir valare help aayi

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

    Concise & clear ...

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

    Adipoli Video !! Really useful

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

    Excellent work

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

    Powli vedio class🥰🤟🤟

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

    Very useful sir.

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

    Helpful video... Thanks...

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

    very good presentation

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

    Sir, organisation chart ഉണ്ടാക്കുന്ന വിധം വീഡിയോ ചെയ്യാമോ

  • @muhammedshajikp.m.3139
    @muhammedshajikp.m.3139 4 роки тому +3

    It’s nice 👍🏻

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

    Good information good luck

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

    Good One 🥇

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

      Thank you.
      I have more video on Excel Shortcuts. Please check that too.

  • @sonythomas100
    @sonythomas100 4 роки тому +2

    very useful shortcuts thanks

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

    Please add a contents page showing time to navigate to particular topic

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

    Thank u,,super

  • @sreejith282
    @sreejith282 4 роки тому +2

    Sir,PDF file MB kurakkan pattumo, vera oru application use cheyyathai.

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

      You should try a PDF Compression software for that. Google for the term 'Compress PDF'

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

    Very help ful👍

  • @മഹാകവിഅർജുനൻ-വ1യ

    Good presentation ❤👍

  • @muhammedshajikp.m.3139
    @muhammedshajikp.m.3139 4 роки тому +4

    Sir, As you said last in the video for 200 Short cuts explanation video, could I have please that link? Or still pending?
    Your videos are quite appreciable!!
    Regards

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

      I am still working on that video and it will take time for the final cut. But you can check these videos on my another UA-cam channel
      ua-cam.com/video/ynk01mkeK7Y/v-deo.html
      ua-cam.com/video/mRpKwsnydM4/v-deo.html
      ua-cam.com/video/kOmPcBY6ap8/v-deo.html

    • @muhammedshajikp.m.3139
      @muhammedshajikp.m.3139 4 роки тому

      XL n CAD Malayalam 👍🏻

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

      I have added these shortcuts to my website. Pls check.
      xlncad.com/excel-shortcuts/

  • @ivankorahabraham
    @ivankorahabraham 4 роки тому +2

    Very useful.

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

    thank a lot for this video

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

    Great work

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

    Well explained 👍🏻

  • @bineeshvydu9707
    @bineeshvydu9707 4 роки тому +2

    Cursor move aakunna sthalathu highlight cheyyan ulla reethi onnu parayaamo ?

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

      I have done a video on the technique to highlight the Active Cell in a worksheet. Please go through the videos section of this channel to find it.
      Highlighting cursor is related to settings of the Operating System.

  • @aswatthyv.m1461
    @aswatthyv.m1461 4 роки тому +2

    Very interesting..

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

    Than you so much

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

    Very useful ❤️

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

      Thank you. I have one more video on Excel Shortcuts. Pls check that too.

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

    Thank you...

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

    Excellent explanation! Can we adjust height of wordlines in a cell ? I tried but failed Pls clarify

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

    Alt+E+S+V kidu👍

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

    Hai its very use full thank u so much,, and to create new chart alt+f1 its not working,

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

    Ma kayinja oralk Dca, ms office ' data entry ivayil yethaanu bettr.pls reply

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

    Very Useful 👍

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

    Sir, Could you explain to calculate Over time from Monday to Sunday. Because Monday to Friday after 8 hrs only over time. But week days if any time is over time. How we can calculate over time from Monday to Sunday in single XL sheet

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

    Nammal Oru pad sheetulla Oru documentil sheet 20 kittanamenkil aroo key allatha shortcut enthenkilum undoo

  • @anseenaanas4196
    @anseenaanas4196 4 роки тому +2

    Nammal data enter cheyyumbol thazhoot kure aay kazhiyumbol mukalilathe heading or serial no.kanaan vendi enth cheyyanam

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

      You can use the Freeze pane option for the same.
      For example your headings are in Row number 3 and you want the headers to stay visible when you scroll down.
      Select Row number 3 > Go to the View tab in the Excel ribbon > Free Panes > Freeze Panes
      Another option is using Excel Tables. Please refer to my video on Advantages of using Excel Tables.

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

    Valiya page print cheyyumbo 2 or 3 pagilayitaan print varunnat. Aa varunna paginellam 1st pagile athe heading nganeya varuka......?

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

      Go to the Page Layout tab > Print Titles> in the Page setup dialog, go to the Sheet tab > Rows to Repeat at top > select the rows containing Headers to repeat in every page and click OK

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

    To Insert a Row we can use Alt+I+R
    To insert a Column we can use Alt+I+C

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

    Excellent

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

    very helpfull videos

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

    excellent

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

    very very helpful

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

    How to ലെറ്റർഹെഡ് in എക്സൽ sheet

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

    I have one doubt. While using "IF" function, can we select a cell in which a date is showing as a result of a formula?

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

      Yes.

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

      @@XLnCADMalayalam it was not working for me, when I used it. May be some error in the format I used. If possible, kindly guide me.

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

    Thank you 😌 sir

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

    Super class sir

  • @SANALKUMARAS
    @SANALKUMARAS Рік тому +1

    Thanks🙏🏼

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

    Oru figure automatic aayi in words mattoru cellil varanulla xl command undo

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

      I have two videos on that Topic (Convert Numbers into Words). Please go through the videos section of this channel to find that videos.

  • @bigb2499
    @bigb2499 3 роки тому +6

    സർ ഡൗട്ട് ചോദിക്കാൻ നമ്മളെ പാസ്പോർട്ട് സ്കാൻ ചെയ്യുമ്പോൾ ഒരുമിച്ച് ഒരു പിഡിഎഫ് ഫയൽ ആക്കാൻ എന്താ മാർഗം

    • @vasunil1
      @vasunil1 3 роки тому +9

      സ്കാൻ ചെയ്യുമ്പോൾ ഓരോ പേജിനു ശേഷവും exit/finish ചെയ്യാതെ പുതിയ പേജ് വെച്ചു scan ചെയ്യുക. എല്ലാ പേജും കഴിഞ്ഞ ശേഷം finish ചെയ്യുക. അപ്പോൾ ഒറ്റ ഫയലായി കിട്ടും.
      ഇനി അഥവാ പല പേജ് ആയിട്ടാണെങ്കിലും ശരിയാക്കാം. ADOBE PDF ൽ ഒരു file OPEN ചെയ്താൽ മുകളിൽ ഒരു പച്ച + കാണും. ഇല്ലെങ്കിൽ combine files എന്ന tab കാണും. അതിനു ശേഷം ചേർക്കേണ്ട file ചോദിക്കും. അപ്പോൾ ആവശ്യമുള്ള പേജ് എല്ലാം സെലക്ട് ചെയ്യുക. വേണമെങ്കിൽ പേജുകളുടെ ഓർഡർ മാറ്റാം. എന്നിട്ട് combine ക്ലിക്ക് ചെയ്യുക. ഒറ്റ ഫയലായി വരും. Default ആയി Binder എന്ന പേരായിരിക്കും. അതു ആവശ്യം പോലെ തിരുത്തി save ചെയ്യുക.

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

      Adobe scan play store

  • @nadvi2007
    @nadvi2007 3 роки тому +21

    word ൽ ഉള്ളത് പോലെ , type ചെയ്യുമ്പോൾ ആദ്യാക്ഷരം capital letter ആയി വരാൻ വല്ല മാർഗ്ഗവും ഉണ്ടോ ?

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

      Proper formula use cheyta madi

    • @anukrishnan7678
      @anukrishnan7678 3 роки тому +6

      =Proper ( select the cell containing text)

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

      Use the formula - Proper

    • @litheshp7819
      @litheshp7819 11 місяців тому

      Proper or Flash will key

  • @AnilKumar-qx9xb
    @AnilKumar-qx9xb 4 роки тому +14

    സർ , ഒരു വലിയ സ്പ്രെഡ് ഷീറ്റ് എങ്ങിനെയാണ് ഒരു A4 പേജിൽ ചുരുക്കി പ്രിൻറ് എടുക്കുന്നത് .. ഒന്ന് വിശദമാക്കാമോ?

    • @XLnCADMalayalam
      @XLnCADMalayalam  4 роки тому +20

      You can adjust the number of sheets and more using the Page Setup option.
      CTRL + P > Page Setup > in the Page Setup dialog, select the option 'Fit to *1* Page wide by *1* tall'

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

      Njn agarahicha chodhiyam thanks man