Excel Autofill - how to quickly enter Months, Days, Dates and Numbers without typing

JoeComputerTips...
Excel 2010 Autofill data. Use your mouse to enter months, days of the week and dates into a worksheet. Learn how to easily count in Excel.
JoeComputerTips...

[@vishwajitm4562]

Can't be taught more clearly and precisely! Thanks Joe!

[@barbaralandry4799]

Thank you so much. For years I’ve been setting up a spreadsheet to track my vitals. I’ve been typing each date separately. What a time saver

[@the_endling]

almost 11 years old and still helpful :) I was going crazy since I remembered I had to drag down the mouse but wasn't doing it from the little square !

[@t_min_o]

He taught simple trick which is a life saver, without using any crazyy formulae

[@sihonghuang693]

When 3: 00, It's exactly what I need to know！I was trying to figure out for like about 30min....and now i got it, It's really helped ！Thank you so much ！

[@avril4835]

coincidence 😳 its 3:30 here

[@jonathanbailey5896]

Hi mate you have no idea as to how useful that was. Simple to the point and it works... thank you so much for your excellent presentation!!!!

[@sarahbostock3688]

Thank you so much! I've been filling dates manually and this is a time saver!

[@farinasyamsul4702]

THANK YOU SO MUCH!!! I WISH THE BEST FOR YOUR LIFE!

[@maridawnica]

Thanks, Joe! This video will help me in my new job! ☺️

[@maridawnica]

By the way, I watched all ads as a way of thanking you.

[@reeree21]

I have to go back and watch those excel videos to learn more haha 2022 still learning excel 😂

[@ThapanDubayehudi]

Miss you Joe

[@paolaa217]

This video was so helpful! You taught me something I’ve been trying to figure out for months now 😅

[@kandyjane21]

So Simple, but amazing time saver. Thank you

[@DLnews-pu6wu]

I looking for this thing perhaps 1 hour finally I got it.
Thank you ❤️❤️

[@amandaloller]

I'm taking an online course and was having problems with the Excel. Your video has helped me so much I am sharing with my class.

[@jodi-ann4083]

Thanks so very much for this information. It will help me a lot in my new position. 😊😊

[@chaisumadsad1074]

I am already your subscriber !!!! Love your tutorials. So easy to follow 😊

[@robincorbett2754]

As an absolute novice I found this very helpful. Thankyou.

[@JaniceWitt]

Hello Joe, I am at my Witts end. I simply need to schedule an excel worksheet for 2 days every week. So every Tuesday and Friday. I am having a horrible time finding a formula or way to do this. Please help??? Sorry...You are wonderful. An excellent instructor and very easy to listen to. Please keep these coming. ;)

[@barrynaad2311]

Did you come right? I'm having the same struggle atm..

[@kevinhill135]

Thank you. You have saved me a lot of time.

[@talykiss1]

hello, i have a problem with dates and months, when I drag the mouse, I get the same day/month copied to other cells. I tried to use Ctrl at the same time as dragging, same result. Also when I click on auto fill options, I have only "copy cells", "fill without formatting", "fill formatting only" and " flash fill". Any solution to this? Thanks

[@Turquoise1971]

I like this guy very straightforward no bs like the British or Indians

[@malcolmstowe2247]

Thank you!!!! Nuff said. Other vids out there were not as illustrative.

[@theliquidllama1]

Your a life saver. Holy shit I was typing in every day separately.

[@bountheathy8988]

Thank you Teacher Joe that teacher us from Video , Could you show us about Series Tool like as : Type and Date Unit Tab ?

[@mhamza3390]

MR. Joes this video really helped me, thank you ！

[@MotherBearth]

THANK YOU!!! You saved me SO MUCH time!

[@olga1886]

Thanks, Joe. I'd like to have in a row May, 2019; June 2019; July 2019 till May, 2021. But when I introduce May, 2019 and June 2019 and select both and drag down I get May, 2020 and June 2020. How I I make sure that when I drag down I get a continuation of the months that year instead of jumping into the next year? Thank you.

[@iam1566]

Great stuff Joe, am surprised you have this small number of subscribers...
You really have simplified understanding computer to a great length

[@rGamingbrotvFr]

Concise and to the point. Excellent!! Thank you.

[@TVSCDN]

Absolutely Fantastic Sir makes life easier workin on EXCEL

[@radzlive1867]

Thank you so much sir, very clear and easy to follow and understand, you helps me a lot... hope more tutorial videos to upload about Microsoft Excel. God bless...

[@tekmepikcha6830]

Still relevant in 2020!!! Thank you Joe!!!

[@pinkgal4ya2]

More helpful than the 4 other top articles and videos I just checked. Thanks!

[@uPVCuPVC]

Thank you for your valuable information it helped me a lot

[@balakrishnankamala3744]

Thank you so much sir. It is very helpful.

[@TheSavethetigers1]

Thank you for showing me this video!

[@fadiac]

Amazing video. It solved my problem. Thank you Sir!

[@marynkengasong2912]

Thanks this has really helped me

[@restaurantrunner761]

-____- watched 2 seconds of this and bam was done with my sheet !!

[@ronaldivey312]

Thanks Joe, very instructional! Excellent Presentation!

[@MoHousen]

Thanks Joe! I apparently made the comment prior to watching the video! Extremely informative!

[@GrahamHorganOnline]

Hi. How do I get fill in increments when I have a letter in it like this (001:A 002:A 003:A 004:A 005:A) I want the number to increase but the rest stay the same? Thank you.

[@maheshkasarla2781]

i need a week ending formula, as weekending is Sun but it should consider the duration from Monday to Sun in the same week.
Eg: we should get the weekending as 17th Dec, 2017, duration starting from 11th of Dec ,17- to 17th, Dec,17.

[@shefinsalim6224]

Thank you for the guidance Joe

[@GurpreetKaur-xj9oh]

When I drag the cell of the date, I clicked on check mark after writing the date, I dragged it, but only years are changing (Not the months)... how to fix that?

[@faezakamal6445]

Same..

[@Tallshipdreamer]

doing every 28 days going across, just fills mine up with hashtags in each block instead of dates

[@TheMakiDoll]

Thank you so much! I found this incredibly useful!

[@gsd2404]

Sir God bless you, ❤

[@Vynessa48]

totally helped with my project right now thank you so much!!!!

[@rajeshkumar-kr8wp]

really i am much satisfied with you tips than so much sir

[@adamdanforth2885]

Very helpful! Thank you!

[@taqi_hassonah5237]

thank you very much you saved my time after spending hours of keep writing dates

[@shinkougo9838]

Hi JoeIt is very helpful, but my question still NOT sloved,
I want to mke a working time tabel for every year and every month, i wish the date(1-31) and weekdag(sun-sat) will change automatly if i change the year(2016 or 2017...) or month( jan or May...)Or can you sent me a link?Thanks

[@overwylde919]

I have the excel 2013, and that move, doesn't work. what should I do?

[@BlissfulBeats]

YOU ARE JUST GREAT SIR

[@mohammedshabaz9215]

Hi,
I have version of 2013 when I select the date and scrolling the mouse only the year is change not day and month is getting change.

[@smikabis2717]

You saved my ass about the 4min mark. Thanks mate!

[@nandiniwalke4736]

I want to make a list of
05-09-2019
05-10-2019
And so on ..
How to do that ?

[@karanknowledge]

one method is:
take three separate columns for day month and year. copy the values of date and year in below cells as it is. start value of month from 1 and increase it by 1 in below columns. now use concatenate all the three columns and make it a date. then use fill handle to copy the formula in below cells.

[@ananthp3200]

i have a doubt,
whether is it possible to add or subract two numbers entered in same cell and output number to be enetered in anohter cell..
that is "21-42 "entered in one cell(for eg A1) the output to be in B2
whether any formula there???..
can anyone help

[@Shazaib432]

Dear sir,
in Asia the formate of the date is.
date/ month / years
how can we change the formate from US TO AISA.??

[@pratiktopiwala4486]

Thank you Mr.Joe

[@poojamathew9130]

Thanks Joe, you saved my time😍, cheers✌️

[@ChoongYeow]

hi may i ask can this works on different pages, eg i got a month of daily data entry but each pages has different day and months. every time i enter this file by end of the month i have to manually changes all the dates on the page to match the current date, is there a method for me to set the page one and auto fill the rest of the pages?

[@robingoyal6650]

VERY USEFUL VIDEO KEEP MAKING SUCH VIDEOS

[@happyboysngals9627]

Thanks, I'm helped. Subscribed.

[@MoHousen]

On a practice test I took recently, I was asked to enter the following text 1895.....900...2020 yet the cell stopped at 34. How was I to use autofill to complete the task? Didn't/Doesn't make sense should this question reappear how should I approach this question? Thanks!

[@yanyan__]

Why i can't do the weekly sequence in my excel

[@karagemma]

Thanks so much! This saved me soo much time! Such a simple thing but know that I know it I'm definitely not going to forget!

[@ariseedu202]

Hi... Thanks a lot u did a great job... Now it's very useful to me... Thanks a lot..

[@satyanantha85]

Great help it was. Bless you God may.

[@masoodomari3610]

Thanks that was really short and great

[@ghulammurtaza8800]

Sir your work is very useful for me. thanks

[@260salim]

I use =if(C5, TODAY(),) then show today's system date. My question is when next day open my PC it is become current system date. How can I fix yesterday date using formula?

[@Underdrummer]

Thank you JOE!

[@neos9708]

good and comprehensive video!

[@jonathantadena8500]

Very well explained.. Godbless

[@astarotish]

Very helpful, thank you, sir

[@syedhassanali5538]

Well needed video

[@sunkaramukesh6012]

Hi sir, your video is really helpful, thanks for your valuable time spending for us. i would like to know to how keep serial internal of time period by dragging just like keeping serial numbers i.e., 7.00 - 7.15 in one cell, i want it to increase with 15min, 7.15 - 7.30, 7.30 - 7.45 .......
thank you in advance'

[@KarabillGR]

I am trying it but it copy the month not add the next month. pls help me

[@cathieadamson8272]

Thank you for making it simple!! Very helpful!!

[@tanvirsyed5368]

Thank you so much . I was stuck in my excel how to enter auto number . Thank you so much

[@sainthardcorps]

Saved my butt at work, cheers!

[@christinalee168]

Wow Very useful. How can I increase only month?

[@rizwanshahzad2054]

Thanks a lot for sharing your priceless knowledge.

[@taufiqueahmed484]

I was exactly looking for this. Thanks a lot

[@sorin990]

Cool video ...could you tell me please how to find the predominant number from a huge list of repetative numbers ? :)

[@jimburrell3148]

Useful thanks and well explained. Will follow your other You Tubes

[@kgncreations7661]

Dear sir,
How to create daily weekly off A shift, b shift, C shift and General shift in excel.

[@cranejayromano]

Thank you, thank you and thank you!! This was definitely a time saver for my project :)

[@drewdiokno6874]

08/01/2018 is being read by excel as Jan. 08,2018 instead of August 01,2018. How to fixed this?

[@PMPM-um6vw]

Thank and Thank you for sharing. This saved me alot of time!

[@mahicharan1313]

Thank you so Much sir

[@jonathanbailey5896]

thanks Joe

[@MBBSZaraHutKay]

Love it. Thank You Sir

[@videosrus8631]

I have tried accessing the website www.JoeComputerTips.com but sadly it no longer exists and is up for sale, which is a shame.

[@joshcampbell6267]

Thank you so much Joe, very helpful.

[@paschameleon]

It doesn't work for me... It just keeps copying the word Janurary

[@BigTestIcles001]

Extremely helpful thanks.