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

Подписаться 254 тыс.

Просмотров 3,5 млн

50% 1

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!

Опубликовано:

15 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 701

@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

@SaliaKeifaNyallay 6 месяцев назад

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.

@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 6 месяцев назад

14years later and it’s helpful

@miguelangel1575 3 года назад

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

@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 😡

@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!

@emandzay 8 лет назад

Thank you for saving me hours of time. Seriously.

@einstienabdullah3320 6 месяцев назад

14 years later...

@ashleyohsosurreal 3 месяца назад

Ah😂

@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 11 месяцев назад

Here from 11 years😊

@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).

@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.

@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...

@rimsha9126 4 месяца назад

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.

@ofonimeobot2023 2 года назад

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

@shamshersultan 2 года назад

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

@josephdinglasa2276 2 года назад

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

@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. :)

@shontellanderson4444 4 года назад

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

@networkmarketingduepoint8044 3 года назад

We need people like you... Am grateful

@jimmyvirustdm5374 2 года назад

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

@MuhammadUsman-pt6wl 4 года назад

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

@64mustangfan 4 месяца назад

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-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..

@adilumrani8891 5 лет назад

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

@motunrayoibitoye5214 2 года назад

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

@abhi303d 3 года назад

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

@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.

@hshrestha2811 3 года назад

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

@trangcaothu1303 8 лет назад

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

@LoyDollhouse 6 лет назад

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

@TeachExcel 6 лет назад

You're welcome! Glad to help :)

@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!

@iamabeinginsearchofmeaning Год назад

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

@jayren9922 3 года назад

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

@hannaassefawoldesemayat2090 2 года назад

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

@sowndararajanstudio1080 2 года назад

Bro thanks for your teach. God bless you all.

@success_consciousss 2 года назад

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

@jesselrico7649 6 месяцев назад

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

@farjanaeti2555 Год назад

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

@jooleeyan6026 2 года назад

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

@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! :)

@tee2001baa Год назад

I needed this at work just today THANK YOU!!

@AllGoodThings007 10 месяцев назад

Thankyou, been looking for something like this for ages

@MrGuerricha 9 лет назад

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

@aasheeshtripathi 3 года назад

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

@arnoldkantumoya8312 4 года назад

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

@TheOn3LeftBehind 2 года назад

Thank you! Exactly the video I was looking for.

@enrikekasijas705 4 года назад

Excel is such a mistery xD thanks for the vid!

@PursueGodliness 4 года назад

So is spelling 😂😇

@colleenslocombe 3 года назад

BEST tutorial ever! thanks for the clarity

@TeachExcel 3 года назад

You are most welcome Mr. Hat! :)

@mindyle2091 Год назад

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

@bentisoy1280 4 года назад

LEGIT TY. YOU SOLVED OUR PROBLEM IN THESIS!

@secretsecret8551 4 года назад

Thank you so much for saving my time and health

@TeachExcel 4 года назад

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

@roshnipeter2300 2 года назад

Very easy to follow. This is very good

@bananahammock9227 3 года назад

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

@chroniclesofnoiks 2 года назад

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

@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

@manatmuzaffar6586 2 года назад

New subscriber sir. you are a legend ❤️

@mojavedon9009 5 лет назад

You are a SUPER STAR! Thanks for your help!

@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!!....

@beastmasteraloha7214 7 лет назад

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

@mohamedhaji2994 7 лет назад

Thanks for teaching us how to number the Excell.

@juvydominguez7014 Год назад

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

@sruthysreekumar807 3 года назад

Thank you the 1st one worked for me 😊

@kevinthomas2470 7 лет назад

Very helpful. I had forgotten how to do this.

@thetaminator2 6 лет назад

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

@TeachExcel 6 лет назад

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 6 лет назад

yup save my life too

@TeachExcel 6 лет назад

@mallidisathireddy2056 4 года назад

Thanks for saving my time..

@cherelemintar4609 3 года назад

Thanks for sharing , God bless 😇😇

@changyintheng747 5 лет назад

You saved my day..Thanks !

@maishair 5 лет назад

what if i wanna do this from anywhere like 550 to onwards... its not working if i am putting 550 in start...

@deodathadeocles1383 4 года назад

Thanks a lot for simplest way

@ahmdouelboayt9703 3 года назад

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

@narendrabs9773 4 года назад

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

@dipankarchakraborty5173 4 года назад

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

@mohammedhashir109 Год назад

13 years😮 thank you its helpful

@nandinichinni8154 3 года назад

Thanks for Saving my time

@princessfloveecastillo2967 3 года назад

thank you!! u just save my life

@sunita3442 2 года назад

thanks brother, you helped me, god bless you.

@ishpreetkaur8650 3 года назад

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

@ainobugabecharles9803 Год назад

This was really helpful thanks big up 👍

@anujdwivedi3742 2 года назад

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

@sunnysharma3401 Год назад

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

@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.🙂

@blueworld2427 3 года назад

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

@jinakhumanthem1296 4 года назад

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

@Alexz_Archivz 4 года назад

Got what i needed @00:40! Thanks

@nawabmulla3354 3 года назад

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

@wmajaji 6 лет назад

you just saved me 20 minutes. thank you!

@adehighwaysvandavasi4872 9 лет назад

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

@giorgidvali951159 Год назад

usefull and practical video. thank you very much!!

@AlisonStreetDesigns 5 лет назад

Thank You saved me so much time trying to figure this out!

@TeachExcel 5 лет назад

You're welcome! :)

@rusheenakhtar1264 2 года назад

Bundle of thanks for helping video

@ltuvatd3division498 5 лет назад

You are a true genius ,sir

@ramitah6855 9 лет назад

The Excel that I use does not have a "fill" option on the category where it says "editing". How can I fix that? Please help.

@shrs.3448 3 года назад

Thank you so much. Excellent idea.

@compufama4678 5 лет назад

Excellent. You just saved my day today. thank you much

@purandarakashyap9648 Год назад

Thanks mate, this was helpful!!

@qijieli8706 9 лет назад

Thank you, you just help to create a series of 10000 data.

@donnatelosenobio5389 4 года назад

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