Effortless Date Autofill In Excel: Make Your Workflow Simpler!

Поділитися
Вставка
  • Опубліковано 3 жов 2024
  • Discover simple techniques to generate a sequence of dates with just a few clicks, eliminating the need for manual entry. Say goodbye to tedious date entry and embrace the efficiency of Excel's autofill feature. Enhance your productivity and simplify your workflow with this essential Excel skill.
    Link to post: www.excelcampu...
    If you found this video useful or you want to see more like this, give it a like 👍
    **JOIN OUR FREE TRAINING SESSION ** excelcampus.co... #shorts #excel
    #ExcelCampus #Exceltips #Rows #Cells #SpreadsheetMagic #productivity

КОМЕНТАРІ • 42

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

    I enjoyed your explanation! I’ve heard people say these various terms, but you really broke them down.👏🏾 The red box was a great touch to emphasize where you’re indicating instead of just the pointer 👍🏾

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

      Thanks for your feedback, Mister! 😀

  • @skip031890
    @skip031890 Рік тому +2

    Excellent. I did not know you could hold the control key to copy the cells down like that. Thank you.

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

    Nice video, easy to copy. Thanks Paul

  • @angelaisland4036
    @angelaisland4036 Рік тому +2

    Great tips Jon! Thank you!

  • @peter-shauntyrell5613
    @peter-shauntyrell5613 8 днів тому

    Thank you!

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

    THANK YOU

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

    Literally took 10 seconds (even less) to explain when there are 2 minute UA-cam videos taking their time to get to the same info. Thank you

  • @SudheerKumar-tb6hw
    @SudheerKumar-tb6hw 2 місяці тому

    IT HELPED ME A LOT THANK YOU SIR

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

    thankyou😊

  • @xaquison
    @xaquison 9 місяців тому +1

    Excellent tip!

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

    Love you sir. It takes many hours for me to set😅 thankyou

  • @lowkeeme
    @lowkeeme 4 місяці тому

    Super thanks!! 🙏🏾

  • @Dancing_Alone_wRentals
    @Dancing_Alone_wRentals 8 місяців тому

    tHanks...I wasn't able to do it. Still, your video was easy to follow and straight to the task. Have a great year ahead!

  • @martineastwood1
    @martineastwood1 10 місяців тому +1

    Thank you sir!

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

    this was really helpful. thank you so much!

    • @ExcelCampus
      @ExcelCampus  7 місяців тому +1

      You're so welcome! 😀

  • @sonal.r.m
    @sonal.r.m 5 місяців тому

    THANKYOUUUU!!!!

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

    Thanks

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

    thanks a lot!

  • @MrImmagod
    @MrImmagod 8 місяців тому +2

    I am struggling, because my fill function does not have the same functions are yours, no weekdays or days functions. Nor do my dates fill in sequentially on the days but on the years. Please help!

    • @ExcelCampus
      @ExcelCampus  8 місяців тому +1

      Hi, Mr! 😀 Different versions of Excel will have different options. Also, the options are different with numbers than with dates (check Ctrl+1 for cell format). When filling, if you select more than one cell before double-clicking, Excel will try to interpret the pattern. Try entering 1/1/2024 next to data, then dragging down to see what happens. Hope that does help! 😎

    • @MrHappy-gr7mb
      @MrHappy-gr7mb 7 місяців тому

      Thanks sir

  • @Mani6TheMan9
    @Mani6TheMan9 Місяць тому

    Is there a way to do this using just the keyboard (no mouse usage)?

  • @rogerlara6586
    @rogerlara6586 4 місяці тому

    Is there any way to input a date into a cell and have it automatically fill the days on the following cells, without dragging handle ? TIA! (ALL WITHIN SAME COLUMN)

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

    Thank u fill options are available in 2016 excel version?

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

    Is this possible with an iPad, no mouse 🤔

  • @josh_lao24
    @josh_lao24 8 місяців тому +1

    It doesn't work. It fills sequential years, not days. Nothing I have tried so far has worked. I need to fill in almost 3 years worth of dates one day at a time.

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

    Is there a way to make it so if i put data into a box i can have another box put the date that i added data? Or do i have to do that manually? In excel or google sheets.

    • @mahally_graphics
      @mahally_graphics 4 місяці тому

      Yes, you can do it with the help of "if" and "sequence" function

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

    The word sequential vs the US date format... A nice pun.