Excel Tips - Quickly Fill Series of Numbers in a Few Seconds Fill Command

Рет қаралды 3,468,267

15 жыл бұрын

Excel VBA/Macros Course (80% Discount): www.teachexcel...
Excel Forum: www.teachexcel...
Visit www.TeachExcel... for more, including Excel Consulting, Macros, and Tutorials.
Learn to quickly fill a large series of number in Microsoft Excel 2007. This tutorial shows you how to put 100,000 numbers in column A in just a few seconds. This is a great way to save time when numbering large sets of data in Excel and it will save you a lot of time. This method is much better than just using the quick-fill handle in Excel.
For Excel consulting or to get the spreadsheet or macro used here visit the website www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.
Have a great day!

Пікірлер: 700

@TeachExcel 3 жыл бұрын

****** BLACK FRIDAY SALE ****** VBA/Macro Course [80% OFF] -> www.teachexcel.com/vba-course-update.php?src=yt_pin_CePq6bnC5oM Professional Forms in Excel [65% OFF] -> www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=yt_pin_CePq6bnC5oM Email from Excel [65% OFF] -> www.teachexcel.com/premium-courses/96/send-emails-from-excel-course?src=yt_pin_CePq6bnC5oM

@juvydominguez7014 Жыл бұрын

sir how about filling the excell numbers to one another eg. 1(11111) 2 (22222) like that please help

@jimbosaul3996 4 жыл бұрын

11 years later, brother, and this is still helpful. easy when you know how. impossible when you dont. god bless you my man !

@KangDeen 3 жыл бұрын

Yes, it is...😀

@erbinay 3 жыл бұрын

Absolutely :)

@bupetute3613 2 жыл бұрын

Yep

@Maame_Ama 5 ай бұрын

14years later and it’s helpful

@faveiconhub9697 4 жыл бұрын

50 secs part of the video I used, and it worked, thank you, I was actually using the slow method untill I thought if it to check online, thanks so much bro, I don't know why some people just like tapping the dislike button 😡

@einstienabdullah3320 5 ай бұрын

14 years later...

@ashleyohsosurreal 2 ай бұрын

Ah😂

@miguelangel1575 3 жыл бұрын

All I needed was your first 53 seconds. You are a like saver!!!

@emandzay 8 жыл бұрын

Thank you for saving me hours of time. Seriously.

@nathanmayo6104 8 жыл бұрын

You must be your mother's favorite child. Thank you so much!

@PursueGodliness 4 жыл бұрын

HAHA

@VidishArvind 3 жыл бұрын

lmao

@PinkAlphaMom 12 жыл бұрын

OMG! I am so glad to have found this tutorial! You saved me so much time on this spreadsheet I am making. I have to increase each number by .25 inches up to 300 inches and i was not looking forward to the task. This got the job done in about 2 seconds! Thanks!!

@traveller0954 10 ай бұрын

Here from 11 years😊

@yvettetrevino8258 2 жыл бұрын

Thank you! I’ve used Excel for years but my mind just went blank on how to add a series of numbers. I appreciate your easy tutorial!

@uroslazic9976 3 жыл бұрын

Just want to leave this comment here saying thank you. Video is more helpful then anything else I have seen on this topic.

@eric-maier 2 жыл бұрын

Great! Thanks! That's how I thought it worked. I was having an issue because it wasn't working for dates. I figured it out though. If you want a series of 2000 dates, you can't step 1 to 2000 because dates are actually serial numbers. You need to figure out your end date serial value and step to that (e.g. date 3/30/22 is serial 44650, so you would step 1 to the needed serial number instead).

@rimsha9126 3 ай бұрын

I tried to find the precise information and I got only from your video...Thanks bro. your video saved my time and saved me to not panicking anymore.

@64mustangfan 3 ай бұрын

Oldie but a goodie! I'm working with a few 100th database lines again. I put a series in most databases, great for filter sorting and cleaning up. Thanks! Btw, I save extra large file as binary spreadsheets (.xlsb), usually reduces sizes significantly.

@user-hp3sd3ny8s 5 ай бұрын

I am Salia Keifa Nyallay, living in Kenema City, Eastern Province of the Republic of Sierra Leone. Thank you so much this tutorial is helpful.

@josephdinglasa2276 2 жыл бұрын

12 year later bro. Ty, big help for a beginner like me.

@ofonimeobot2023 2 жыл бұрын

I paused this video just to tell you that 12years later, this video is still helpful! 🙌🏾 (resumes video…)

@networkmarketingduepoint8044 3 жыл бұрын

We need people like you... Am grateful

@user-dc8iz3ce7r 2 жыл бұрын

Seriously...my teacher explaim to me for like 5-7 times and i dont understand it...but this guy only 2 minute...and i can understand it very well..

@mariamalacria5160 3 жыл бұрын

Thank you so much for your clear and easy to understand tutorial. I have learned basic excel and couldn't remember how to do this. Very grateful...

@shontellanderson4444 4 жыл бұрын

Awesome! I didn't need to look at entire video to complete task. Thank you so much for the video

@shamshersultan 2 жыл бұрын

12yrs later it's still useful, thank you so much 🤩

@iamabeinginsearchofmeaning Жыл бұрын

Thanks for the info That's really time saving This video is helpful at all times

@QudsiaUddin Жыл бұрын

I used to fill numbers manually. Today upon stumbling on your video, I learnt a fun way to do the needful. blessings creator. loved this basic trick.

@learnwithberryafaithfulser5565 6 жыл бұрын

Thank you u helped me in my research .. I can now sleep . Please share more of ur excel expertise so u could help a lot of novice people like me. :)

@jimmyvirustdm5374 2 жыл бұрын

very informative I recommend this channel to you guys, you will not regret

@adilumrani8891 5 жыл бұрын

You my love, firt 20 sec of yours save me whole day.💗🙈

@trangcaothu1303 8 жыл бұрын

Hello, You are my life saver. I would have been dying when generating 100. 000 numbers without your video! T ^ T

@jayren9922 3 жыл бұрын

Thanks, I finally have all the numbers from 1 to 100,000,000 in a single notepad document

@success_consciousss Жыл бұрын

Hey, thankyou so much. I got to learn something new and amazing today. 🙂🙂

@MuhammadUsman-pt6wl 4 жыл бұрын

That was so simple and i put 170 numbers 1 by 1 Thanks for teaching me a new thing

@farjanaeti2555 Жыл бұрын

thank you so so much for helpful video. i watched 5/6 videos but urs is most easier and simple❤

@abhi303d 3 жыл бұрын

From India Thank you so much it's very easy and helpful 🙏✌️

@sneha_d_mystery_princess 3 жыл бұрын

Love You... you solved my problem in first 50 seconds of your video ... :) :)

@oterowilliams-el7755 2 жыл бұрын

Just finished my spreadsheet in a matter of seconds, thanks to this video!

@hannaassefawoldesemayat2090 2 жыл бұрын

The above video was a great help. Thank you very much!

@hshrestha2811 2 жыл бұрын

I am sure this is still going to be relevant and useful for several years to come.

@motunrayoibitoye5214 2 жыл бұрын

12 years ago, woah, thank you so much for this. Followed your instructions and saved me tons!

@TheOn3LeftBehind 2 жыл бұрын

Thank you! Exactly the video I was looking for.

@jooleeyan6026 2 жыл бұрын

I like how this video was posted 3 days after i was born, that's crazy!!

@AllGoodThings007 9 ай бұрын

Thankyou, been looking for something like this for ages

@sowndararajanstudio1080 2 жыл бұрын

Bro thanks for your teach. God bless you all.

@kimcockrum9009 5 жыл бұрын

Thank you so much for the help. So many video"s watched this is the only one that helped.

@TeachExcel 5 жыл бұрын

I'm really glad it helped! :)

@jesselrico7649 5 ай бұрын

Thank you for this tutorial It's quick and easy to learn. 🎉❤

@colleenslocombe 3 жыл бұрын

BEST tutorial ever! thanks for the clarity

@TeachExcel 3 жыл бұрын

You are most welcome Mr. Hat! :)

@changyintheng747 5 жыл бұрын

You saved my day..Thanks !

@arnoldkantumoya8312 4 жыл бұрын

Thank you so much. I had lots of data to enter.

@mindyle2091 Жыл бұрын

I just discovered this tutorial. Very helpful! Thank you so much!

@tee2001baa Жыл бұрын

I needed this at work just today THANK YOU!!

@MrGuerricha 9 жыл бұрын

i REALLY APPRECIATE IT, you've got me subscribed there :)

@bentisoy1280 4 жыл бұрын

LEGIT TY. YOU SOLVED OUR PROBLEM IN THESIS!

@Smtrading530 2 жыл бұрын

Awesome, i have been looking for a lot if days.

@robertskipcurran8401 9 жыл бұрын

Helpful right from the first 60 seconds! Thanks. The "help" for this on the web - not helpful at all. Thanks again

@LoyDollhouse 6 жыл бұрын

I did it and it worked. Thank you for explaining in simple manner.

@TeachExcel 6 жыл бұрын

You're welcome! Glad to help :)

@bananahammock9227 3 жыл бұрын

Long live to you brother. Helped me save my time.

@aasheeshtripathi 3 жыл бұрын

Thank you very much I just got it in 48 seconds and saved my hours

@dipankarchakraborty5173 4 жыл бұрын

thank you very much and extra thanks for the ctrl+arrow key thing i didnt knew that before

@mojavedon9009 5 жыл бұрын

You are a SUPER STAR! Thanks for your help!

@enrikekasijas705 4 жыл бұрын

Excel is such a mistery xD thanks for the vid!

@PursueGodliness 4 жыл бұрын

So is spelling 😂😇

@juvydominguez7014 Жыл бұрын

such a great help especially for the beginners to know the short cut, thanks master

@chroniclesofnoiks Жыл бұрын

12 years later this is still helpfull ...thanks 😊

@kevinthomas2470 7 жыл бұрын

Very helpful. I had forgotten how to do this.

@mallidisathireddy2056 4 жыл бұрын

Thanks for saving my time..

@alialmuhanna4938 2 жыл бұрын

Thank you. How about if a user wants to list monthly figures ? For example, I want to list information starting from January 2018, and then make a forecast until January 2040. Appreciate the help.

@anujdwivedi3742 2 жыл бұрын

i am watching this vedio in 2022 after 12 year ago you make this vedio and this is working till now.

@jinakhumanthem1296 4 жыл бұрын

Great this video solved my problem👍🏻👍🏻👍🏻👍🏻❤

@chascarpenter5006 4 жыл бұрын

Thank you again, wus here several weeks ago & got the hang of it & came to this morning to fill in a form & would'nt work, listen to you for a few seconds & , need to high light the cells!!, job sorted, whats the humming in the back ground!!....

@secretsecret8551 3 жыл бұрын

Thank you so much for saving my time and health

@TeachExcel 3 жыл бұрын

You're very welcome :) I'm glad I could help)

@Mr.Steve-O 9 жыл бұрын

awesome turorial, I use a MAC and have office 2008 on my computer, can this be applied to my software, as I cannot figure how to do this ? Thanks Steve

@roshnipeter2300 2 жыл бұрын

Very easy to follow. This is very good

@beastmasteraloha7214 7 жыл бұрын

you're a good illustrative teacher keep it up thnx for your tutorial videos

@nawabmulla3354 3 жыл бұрын

thank you so much , I was looking for this for weeks

@mohamedhaji2994 7 жыл бұрын

Thanks for teaching us how to number the Excell.

@mohammedhashir109 Жыл бұрын

13 years😮 thank you its helpful

@biplabpramanik7006 4 жыл бұрын

Thank you video. And help ful I'm trying and complete my problem but very find this is video. Thank yoy,Thank you sho Mitch.🙂

@Alexz_Archivz 4 жыл бұрын

Got what i needed @00:40! Thanks

@ahmdouelboayt9703 3 жыл бұрын

thank you too much this so usefull am from morocco thank you toooooo much ♥♥♥♥♥♥♥

@movingtorichmondva 2 жыл бұрын

just what i was looking for, thanks!

@deodathadeocles1383 3 жыл бұрын

Thanks a lot for simplest way

@ltuvatd3division498 5 жыл бұрын

You are a true genius ,sir

@adehighwaysvandavasi4872 9 жыл бұрын

VERY THANKYOU FOR THIS SIMPLE METHOD OF INSERT NUIMBER IN FEW SEC THANK YOU VERY MUCHHHHHHHHHHHHHHHHHHHH......................

@narendrabs9773 4 жыл бұрын

Thanks for this helpful tip. Helpful for beginners just like me.

@wmajaji 6 жыл бұрын

you just saved me 20 minutes. thank you!

@vanessajames3948 3 жыл бұрын

Aww, you're a life saver, thank you.

@sruthysreekumar807 3 жыл бұрын

Thank you the 1st one worked for me 😊

@kentonrune6621 4 жыл бұрын

thanks! this is a quick and easy way, just as I needed!!

@rusheenakhtar1264 2 жыл бұрын

Bundle of thanks for helping video

@cherelemintar4609 3 жыл бұрын

Thanks for sharing , God bless 😇😇

@ishpreetkaur8650 3 жыл бұрын

You saved my lot of time ..thanks sir !!

@thetaminator2 5 жыл бұрын

Thank you so much!!! I have been trying to do this for 2 days!!!!!! Thank you thank you thank you!!!!!!!

@TeachExcel 5 жыл бұрын

I'm so glad it helped :) If you have any more issues, don't wait 2 days! Just ask on our forum :) www.teachexcel.com/talk/microsoft-office?src=yt

@awaisqurashi7984 5 жыл бұрын

yup save my life too

@TeachExcel 5 жыл бұрын

@sorin990 9 жыл бұрын

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

@sunnysharma3401 Жыл бұрын

Awesome 👌👏👍😍........it is still helpful thank you so much 💓💖

@blueworld2427 3 жыл бұрын

Thank you so much. You are amazing. I just subscribed.

@nandinichinni8154 3 жыл бұрын

Thanks for Saving my time

@donnatelosenobio5389 4 жыл бұрын

Thank you this is powerful tutorial. You save my time.

@purandarakashyap9648 Жыл бұрын

Thanks mate, this was helpful!!

@fluffy6566 8 жыл бұрын

You saved my life!

@ainobugabecharles9803 Жыл бұрын

This was really helpful thanks big up 👍

@sciuto-moto1584 8 жыл бұрын

you just saved me so much time thank you

@subhojitnath3127 4 жыл бұрын

Thanks, man....you saved my day...thank you

@masoodshah7882 7 жыл бұрын

how to fill series of numbers if you have skipped 1 row after 1 or 2 or 3 rows ??