Excel Autofill - how to quickly enter Months, Days, Dates and Numbers without typing
Вставка
- Опубліковано 27 сер 2024
- 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...
Can't be taught more clearly and precisely! Thanks Joe!
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
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 !
He taught simple trick which is a life saver, without using any crazyy formulae
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 !
coincidence 😳 its 3:30 here
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!!!!
Thank you so much! I've been filling dates manually and this is a time saver!
THANK YOU SO MUCH!!! I WISH THE BEST FOR YOUR LIFE!
Thanks, Joe! This video will help me in my new job! ☺️
By the way, I watched all ads as a way of thanking you.
I have to go back and watch those excel videos to learn more haha 2022 still learning excel 😂
Miss you Joe
This video was so helpful! You taught me something I’ve been trying to figure out for months now 😅
So Simple, but amazing time saver. Thank you
I looking for this thing perhaps 1 hour finally I got it.
Thank you ❤️❤️
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.
Thanks so very much for this information. It will help me a lot in my new position. 😊😊
I am already your subscriber !!!! Love your tutorials. So easy to follow 😊
As an absolute novice I found this very helpful. Thankyou.
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. ;)
Did you come right? I'm having the same struggle atm..
Thank you. You have saved me a lot of time.
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
I like this guy very straightforward no bs like the British or Indians
Thank you!!!! Nuff said. Other vids out there were not as illustrative.
Your a life saver. Holy shit I was typing in every day separately.
Thank you Teacher Joe that teacher us from Video , Could you show us about Series Tool like as : Type and Date Unit Tab ?
MR. Joes this video really helped me, thank you !
THANK YOU!!! You saved me SO MUCH time!
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.
Great stuff Joe, am surprised you have this small number of subscribers...
You really have simplified understanding computer to a great length
Concise and to the point. Excellent!! Thank you.
Absolutely Fantastic Sir makes life easier workin on EXCEL
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...
Still relevant in 2020!!! Thank you Joe!!!
More helpful than the 4 other top articles and videos I just checked. Thanks!
Thank you for your valuable information it helped me a lot
Thank you so much sir. It is very helpful.
Thank you for showing me this video!
Amazing video. It solved my problem. Thank you Sir!
Thanks this has really helped me
-____- watched 2 seconds of this and bam was done with my sheet !!
Thanks Joe, very instructional! Excellent Presentation!
Thanks Joe! I apparently made the comment prior to watching the video! Extremely informative!
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.
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.
Thank you for the guidance Joe
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?
Same..
doing every 28 days going across, just fills mine up with hashtags in each block instead of dates
Thank you so much! I found this incredibly useful!
Sir God bless you, ❤
totally helped with my project right now thank you so much!!!!
really i am much satisfied with you tips than so much sir
Very helpful! Thank you!
thank you very much you saved my time after spending hours of keep writing dates
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
I have the excel 2013, and that move, doesn't work. what should I do?
YOU ARE JUST GREAT SIR
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.
You saved my ass about the 4min mark. Thanks mate!
I want to make a list of
05-09-2019
05-10-2019
And so on ..
How to do that ?
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.
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
Dear sir,
in Asia the formate of the date is.
date/ month / years
how can we change the formate from US TO AISA.??
Thank you Mr.Joe
Thanks Joe, you saved my time😍, cheers✌️
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?
VERY USEFUL VIDEO KEEP MAKING SUCH VIDEOS
Thanks, I'm helped. Subscribed.
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!
Why i can't do the weekly sequence in my excel
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!
Hi... Thanks a lot u did a great job... Now it's very useful to me... Thanks a lot..
Great help it was. Bless you God may.
Thanks that was really short and great
Sir your work is very useful for me. thanks
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?
Thank you JOE!
good and comprehensive video!
Very well explained.. Godbless
Very helpful, thank you, sir
Well needed video
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'
I am trying it but it copy the month not add the next month. pls help me
Thank you for making it simple!! Very helpful!!
Thank you so much . I was stuck in my excel how to enter auto number . Thank you so much
Saved my butt at work, cheers!
Wow Very useful. How can I increase only month?
Thanks a lot for sharing your priceless knowledge.
I was exactly looking for this. Thanks a lot
Cool video ...could you tell me please how to find the predominant number from a huge list of repetative numbers ? :)
Useful thanks and well explained. Will follow your other You Tubes
Dear sir,
How to create daily weekly off A shift, b shift, C shift and General shift in excel.
Thank you, thank you and thank you!! This was definitely a time saver for my project :)
08/01/2018 is being read by excel as Jan. 08,2018 instead of August 01,2018. How to fixed this?
Thank and Thank you for sharing. This saved me alot of time!
Thank you so Much sir
thanks Joe
Love it. Thank You Sir
I have tried accessing the website www.JoeComputerTips.com but sadly it no longer exists and is up for sale, which is a shame.
Thank you so much Joe, very helpful.
It doesn't work for me... It just keeps copying the word Janurary
Extremely helpful thanks.