How to Use AutoFill in Excel (Best Practices)

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

КОМЕНТАРІ • 105

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

    Thank you so much easy click, it makes my study about autofill feature very easy!!

  • @Yogasefski
    @Yogasefski 7 місяців тому

    Just saved me 2 hours of work, thanks!

  • @kaivalyahandge
    @kaivalyahandge 9 місяців тому

    it's the best video I have ever seen

  • @HaniEshal
    @HaniEshal 3 місяці тому

    Thank you❤

  • @HarshitaDeb-p6x
    @HarshitaDeb-p6x Рік тому

    It was very helpful for me i am learning this in my exam morning btw thank you for this understanding video ❤ u saved me

  • @shedholekata4248
    @shedholekata4248 7 місяців тому

    Thanks for great lesson. You are amazing❤

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

    Can you autofill phrases with characters? (i.e. TEXT-x(a)(y)) x and x are integers which should remain constant; the 'a' should move alphabetically. Thanks!

  • @creepymcpeepers
    @creepymcpeepers 3 роки тому +13

    What if the auto fill button doesn’t pop up when we highlight the rows

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

      good question

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

      @@josettekasereka1320 hey I can tell you how. You go just to the right corner line the pointer with the bottom right corner just perfectly. Then you pull down….

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

      @@josettekasereka1320 it’s kind of tricky but you have to do it just right I learned it the other day when I got mad and smashed a guitar

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

      If you don't see the autofill marker when you highlight the cell and place the mouse on the right hand corner try this fix ua-cam.com/video/ndRbtneVdtU/v-deo.html

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

      Yess

  • @estherfernandes5522
    @estherfernandes5522 3 роки тому +7

    It helped me a lot

  • @Ambassador_Gkar
    @Ambassador_Gkar 6 місяців тому

    A concise, simplified explanation, of using autofill, from within the spreadsheet. 👍
    It could have been improved with a short reference to how to access the option, via 'customise the ribbon,' for saving custom autofill data.
    Not a criticism; just a way to improve on a great, little tip, for bettering spreadsheet skills, like I am, through self-education. The reason I came here, as I liked the title.

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

    Thank you alot! This helped me out alot since I forgot how to use autofill and I have a computer exam tomorrow! Your channel is the best I am subscribing

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

    Very Nice
    Thankyou so much

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

    thanks it helps a lot!🙂

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

    THANK YOU!

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

    Can you formulate in one cell to command auto fill the series of number in rows without draging or copy? Ex: i enter a number in 1 cell "5" the result is it automate the series of number from 1 to 5 in rows dropdown. Thanx!

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

      Place 1 in a cell, then Home --> Fill --> Series, select Series in Columns, Step value 1, Stop Value 5, press OK button.

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

    Thanks for the tutorial. What is the shortcut to fill the series for the column, rather than dragging the mouse down page after page?

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

    You just saved my life!!

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

    thanks for the tutorial

  • @ayyanzchannel2.0
    @ayyanzchannel2.0 7 місяців тому

    THANKS FR IG

  • @PoonamKumari-tu7ft
    @PoonamKumari-tu7ft 3 роки тому

    Thanku mam it is so helpful for me tomorrow is my computer practical test

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

    Very easy & helpful, Thanks

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

    how do you create a series where 2 blocks are the same value, ie in a column two of the same date then two of the next date and so on?

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

      You can try the Flash Fill which is the "smart" autofill check this video ua-cam.com/video/3kg4acnFC48/v-deo.html

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

      @@iKnowledgeSchool

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

      @@iKnowledgeSchool

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

    😅Thank you for your information

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

    Thnku so much ❤😁

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

    Thank you for the information

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

    It's very easy.

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

    Thanks a million O my dear!

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

    U were amazing ☺️☺️

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

    Thanks madam I am from india

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

    Thank you.

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

    you are like the Excel flash

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

    I love it💟

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

    Thank yous o much!!!

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

    Màm your videos are amazing

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

    Thank you ma'am

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

    Very helpful! May Jesus bless you guys💕💕

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

    Great learning

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

    Thank you 🌹

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

    Nice❤❤❤❤❤

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

    Thanks 👍👍😊 nice

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

    How to fill series in alternate cells..is it possible?

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

    Hi maria , Video very usefull & really help lot.i need to practice can you share practice file.....

  • @Nawazish.vlogs.singing
    @Nawazish.vlogs.singing Рік тому

    Share auto fill of FREE TEXT auto updation in next column against previous colum 123 value

  • @RahulSingh-dn1qf
    @RahulSingh-dn1qf Рік тому

    Amazing

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

    Can we use A TO Z to autofll

  • @Migueltee96
    @Migueltee96 5 років тому +4

    Great info i love excel. I'm trying to learn more about how to create formulas

    • @ExcelTutorialsEasyClickAcademy
      @ExcelTutorialsEasyClickAcademy  5 років тому +1

      Thanks Rohan for your feedback. :) We are very happy that our video helped you. Learn more great info also from another our tutorials. :)

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

    Thank you

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

    Hi teacher. I don't know what is the problem of my excel. I can not Auto fill same you.

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

    Thx lots

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

    Nice mam

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

    pl teach me flash 8.im very weary about it. 👏👏👏🏻

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

      Baasudebdutta thank you for your comment. Our specialization is Microsoft Excel. Tutorials for flash 8 you can find in different UA-cam channel. :)

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

    Dear is there any shortcut or keyboard key of this autofill

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

    Thankyou🙏

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

    Good video

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

    I fill or type something on a page of excel, how will it appear on a different page? Please guide

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

      Try inserting in the different page =firstpagecell hope this helps

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

    Thank

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

    Very very nice veido

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

    "simply roll out the autofill options..." - how am I supposed to do that?

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

      click on the tiny arrow that she clicked

  • @AliAbbas-uh4oy
    @AliAbbas-uh4oy 4 роки тому +3

    Thanks

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

    Super

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

    Dear we need to know a bout Sires as Date Unit , Date , Week day ,Month ,Year

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

    Nice

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

    How about complete dates

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

    ❤❤❤❤❤❤

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

    how to see fill hand in excel with keyboard

  • @rajva.puthiyath9414
    @rajva.puthiyath9414 4 місяці тому

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

    How to quickly fill a row

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

    By using fill u can do this.

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

    Wow

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

    u didnt show for people who do't even have the menu that lil one !!

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

    Tq

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

    How do I autofill without increments?

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

      Flash fill may do the trick ua-cam.com/video/3kg4acnFC48/v-deo.html

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

    Can you teach formulas in excel I am in 6 th class

  • @HarmeetKaur-zz5no
    @HarmeetKaur-zz5no 4 роки тому +3

    i can't understood plz explain once again 🙏

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

    Not able to use autofill

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

    I am trying to auto fill R1 C1 to R1 C10 and then R2 C1 to R2 C10, etc. Your method did not work.

  • @sunilkumar-ts9fb
    @sunilkumar-ts9fb 3 роки тому

    Make a word table

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

    WAVERLY EARRRRRP!!!!???????

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

    Uwu

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

    A-Z

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

    Training get

  • @SurenderKumar-pe5nc
    @SurenderKumar-pe5nc Рік тому

    Please speak slowly

  • @Mr.Unknownman14
    @Mr.Unknownman14 4 роки тому +3

    Explain in hindi

  • @heathergreen-d4k
    @heathergreen-d4k 2 місяці тому

    buhb

  • @RamjiiTripathi
    @RamjiiTripathi 3 місяці тому

    Your are so bad teacher

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

    Very helpful! May Jesus bless you guys💕💕