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

  Рет қаралды 3,534,868

TeachExcel

TeachExcel

Күн бұрын

Пікірлер: 706
@TeachExcel
@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
@juvydominguez7014 Жыл бұрын
sir how about filling the excell numbers to one another eg. 1(11111) 2 (22222) like that please help
@SaliaKeifaNyallay
@SaliaKeifaNyallay 10 ай бұрын
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.
@PinkAlphaMom
@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
@traveller0954 Жыл бұрын
Here from 11 years😊
@jimbosaul3996
@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
@KangDeen 4 жыл бұрын
Yes, it is...😀
@erbinay
@erbinay 3 жыл бұрын
Absolutely :)
@bupetute3613
@bupetute3613 2 жыл бұрын
Yep
@Maame_Ama
@Maame_Ama 11 ай бұрын
14years later and it’s helpful
@faveiconhub9697
@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 😡
@miguelangel1575
@miguelangel1575 4 жыл бұрын
All I needed was your first 53 seconds. You are a like saver!!!
@emandzay
@emandzay 9 жыл бұрын
Thank you for saving me hours of time. Seriously.
@nathanmayo6104
@nathanmayo6104 9 жыл бұрын
You must be your mother's favorite child. Thank you so much!
@PursueGodliness
@PursueGodliness 4 жыл бұрын
HAHA
@VidishArvind
@VidishArvind 3 жыл бұрын
lmao
@uroslazic9976
@uroslazic9976 4 жыл бұрын
Just want to leave this comment here saying thank you. Video is more helpful then anything else I have seen on this topic.
@yvettetrevino8258
@yvettetrevino8258 3 жыл бұрын
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!
@eric-maier
@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
@rimsha9126 8 ай бұрын
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.
@iamabeinginsearchofmeaning
@iamabeinginsearchofmeaning Жыл бұрын
Thanks for the info That's really time saving This video is helpful at all times
@networkmarketingduepoint8044
@networkmarketingduepoint8044 3 жыл бұрын
We need people like you... Am grateful
@shontellanderson4444
@shontellanderson4444 4 жыл бұрын
Awesome! I didn't need to look at entire video to complete task. Thank you so much for the video
@mariamalacria5160
@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...
@einstienabdullah3320
@einstienabdullah3320 10 ай бұрын
14 years later...
@ashleyohsosurreal
@ashleyohsosurreal 8 ай бұрын
Ah😂
@josephdinglasa2276
@josephdinglasa2276 3 жыл бұрын
12 year later bro. Ty, big help for a beginner like me.
@sneha_d_mystery_princess
@sneha_d_mystery_princess 4 жыл бұрын
Love You... you solved my problem in first 50 seconds of your video ... :) :)
@learnwithberryafaithfulser5565
@learnwithberryafaithfulser5565 7 жыл бұрын
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. :)
@LoyDollhouse
@LoyDollhouse 6 жыл бұрын
I did it and it worked. Thank you for explaining in simple manner.
@TeachExcel
@TeachExcel 6 жыл бұрын
You're welcome! Glad to help :)
@jimmyvirustdm5374
@jimmyvirustdm5374 2 жыл бұрын
very informative I recommend this channel to you guys, you will not regret
@AllGoodThings007
@AllGoodThings007 Жыл бұрын
Thankyou, been looking for something like this for ages
@64mustangfan
@64mustangfan 8 ай бұрын
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.
@ofonimeobot2023
@ofonimeobot2023 3 жыл бұрын
I paused this video just to tell you that 12years later, this video is still helpful! 🙌🏾 (resumes video…)
@shamshersultan
@shamshersultan 2 жыл бұрын
12yrs later it's still useful, thank you so much 🤩
@tee2001baa
@tee2001baa Жыл бұрын
I needed this at work just today THANK YOU!!
@colleenslocombe
@colleenslocombe 3 жыл бұрын
BEST tutorial ever! thanks for the clarity
@TeachExcel
@TeachExcel 3 жыл бұрын
You are most welcome Mr. Hat! :)
@adilumrani8891
@adilumrani8891 5 жыл бұрын
You my love, firt 20 sec of yours save me whole day.💗🙈
@hannaassefawoldesemayat2090
@hannaassefawoldesemayat2090 2 жыл бұрын
The above video was a great help. Thank you very much!
@sowndararajanstudio1080
@sowndararajanstudio1080 2 жыл бұрын
Bro thanks for your teach. God bless you all.
@abhi303d
@abhi303d 3 жыл бұрын
From India Thank you so much it's very easy and helpful 🙏✌️
@ainobugabecharles9803
@ainobugabecharles9803 Жыл бұрын
This was really helpful thanks big up 👍
@trangcaothu1303
@trangcaothu1303 8 жыл бұрын
Hello, You are my life saver. I would have been dying when generating 100. 000 numbers without your video! T ^ T
@kimcockrum9009
@kimcockrum9009 6 жыл бұрын
Thank you so much for the help. So many video"s watched this is the only one that helped.
@TeachExcel
@TeachExcel 6 жыл бұрын
I'm really glad it helped! :)
@farjanaeti2555
@farjanaeti2555 Жыл бұрын
thank you so so much for helpful video. i watched 5/6 videos but urs is most easier and simple❤
@apfitz
@apfitz 2 жыл бұрын
Thank you! Exactly the video I was looking for.
@MuhammadUsman-pt6wl
@MuhammadUsman-pt6wl 4 жыл бұрын
That was so simple and i put 170 numbers 1 by 1 Thanks for teaching me a new thing
@oterowilliams-el7755
@oterowilliams-el7755 2 жыл бұрын
Just finished my spreadsheet in a matter of seconds, thanks to this video!
@success_consciousss
@success_consciousss 2 жыл бұрын
Hey, thankyou so much. I got to learn something new and amazing today. 🙂🙂
@thetaminator2
@thetaminator2 6 жыл бұрын
Thank you so much!!! I have been trying to do this for 2 days!!!!!! Thank you thank you thank you!!!!!!!
@TeachExcel
@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
@awaisqurashi7984 6 жыл бұрын
yup save my life too
@TeachExcel
@TeachExcel 6 жыл бұрын
:)
@arnoldkantumoya8312
@arnoldkantumoya8312 4 жыл бұрын
Thank you so much. I had lots of data to enter.
@mindyle2091
@mindyle2091 Жыл бұрын
I just discovered this tutorial. Very helpful! Thank you so much!
@hshrestha2811
@hshrestha2811 3 жыл бұрын
I am sure this is still going to be relevant and useful for several years to come.
@MrGuerricha
@MrGuerricha 10 жыл бұрын
i REALLY APPRECIATE IT, you've got me subscribed there :)
@motunrayoibitoye5214
@motunrayoibitoye5214 3 жыл бұрын
12 years ago, woah, thank you so much for this. Followed your instructions and saved me tons!
@bananahammock9227
@bananahammock9227 3 жыл бұрын
Long live to you brother. Helped me save my time.
@Alexz_Archivz
@Alexz_Archivz 4 жыл бұрын
Got what i needed @00:40! Thanks
@jesselrico7649
@jesselrico7649 11 ай бұрын
Thank you for this tutorial It's quick and easy to learn. 🎉❤
@bentisoy1280
@bentisoy1280 4 жыл бұрын
LEGIT TY. YOU SOLVED OUR PROBLEM IN THESIS!
@Smtrading530
@Smtrading530 3 жыл бұрын
Awesome, i have been looking for a lot if days.
@mojavedon9009
@mojavedon9009 5 жыл бұрын
You are a SUPER STAR! Thanks for your help!
@manatmuzaffar6586
@manatmuzaffar6586 2 жыл бұрын
New subscriber sir. you are a legend ❤️
@jayren9922
@jayren9922 4 жыл бұрын
Thanks, I finally have all the numbers from 1 to 100,000,000 in a single notepad document
@secretsecret8551
@secretsecret8551 4 жыл бұрын
Thank you so much for saving my time and health
@TeachExcel
@TeachExcel 4 жыл бұрын
You're very welcome :) I'm glad I could help)
@roshnipeter2300
@roshnipeter2300 2 жыл бұрын
Very easy to follow. This is very good
@GAMING25-x3f
@GAMING25-x3f 3 жыл бұрын
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..
@changyintheng747
@changyintheng747 5 жыл бұрын
You saved my day..Thanks !
@nawabmulla3354
@nawabmulla3354 4 жыл бұрын
thank you so much , I was looking for this for weeks
@jinakhumanthem1296
@jinakhumanthem1296 4 жыл бұрын
Great this video solved my problem👍🏻👍🏻👍🏻👍🏻❤
@sruthysreekumar807
@sruthysreekumar807 3 жыл бұрын
Thank you the 1st one worked for me 😊
@juvydominguez7014
@juvydominguez7014 Жыл бұрын
such a great help especially for the beginners to know the short cut, thanks master
@aasheeshtripathi
@aasheeshtripathi 4 жыл бұрын
Thank you very much I just got it in 48 seconds and saved my hours
@beastmasteraloha7214
@beastmasteraloha7214 7 жыл бұрын
you're a good illustrative teacher keep it up thnx for your tutorial videos
@dipankarchakraborty5173
@dipankarchakraborty5173 4 жыл бұрын
thank you very much and extra thanks for the ctrl+arrow key thing i didnt knew that before
@blueworld2427
@blueworld2427 3 жыл бұрын
Thank you so much. You are amazing. I just subscribed.
@ltuvatd3division498
@ltuvatd3division498 6 жыл бұрын
You are a true genius ,sir
@ishpreetkaur8650
@ishpreetkaur8650 3 жыл бұрын
You saved my lot of time ..thanks sir !!
@jooleeyan6026
@jooleeyan6026 2 жыл бұрын
I like how this video was posted 3 days after i was born, that's crazy!!
@TalesofmyPluto
@TalesofmyPluto Жыл бұрын
I tried contacting on the links but no response, is the vba course still available?
@robertskipcurran8401
@robertskipcurran8401 10 жыл бұрын
Helpful right from the first 60 seconds! Thanks. The "help" for this on the web - not helpful at all. Thanks again
@ahmdouelboayt9703
@ahmdouelboayt9703 4 жыл бұрын
thank you too much this so usefull am from morocco thank you toooooo much ♥♥♥♥♥♥♥
@subhojitnath3127
@subhojitnath3127 5 жыл бұрын
Thanks, man....you saved my day...thank you
@kentonrune6621
@kentonrune6621 4 жыл бұрын
thanks! this is a quick and easy way, just as I needed!!
@AlisonStreetDesigns
@AlisonStreetDesigns 6 жыл бұрын
Thank You saved me so much time trying to figure this out!
@TeachExcel
@TeachExcel 6 жыл бұрын
You're welcome! :)
@movingtorichmondva
@movingtorichmondva 3 жыл бұрын
just what i was looking for, thanks!
@mallidisathireddy2056
@mallidisathireddy2056 4 жыл бұрын
Thanks for saving my time..
@sciuto-moto1584
@sciuto-moto1584 8 жыл бұрын
you just saved me so much time thank you
@purandarakashyap9648
@purandarakashyap9648 Жыл бұрын
Thanks mate, this was helpful!!
@chroniclesofnoiks
@chroniclesofnoiks 2 жыл бұрын
12 years later this is still helpfull ...thanks 😊
@narendrabs9773
@narendrabs9773 4 жыл бұрын
Thanks for this helpful tip. Helpful for beginners just like me.
@kevinthomas2470
@kevinthomas2470 7 жыл бұрын
Very helpful. I had forgotten how to do this.
@QudsiaUddin
@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.
@cherelemintar4609
@cherelemintar4609 4 жыл бұрын
Thanks for sharing , God bless 😇😇
@sunnysharma3401
@sunnysharma3401 2 жыл бұрын
Awesome 👌👏👍😍........it is still helpful thank you so much 💓💖
@vanessajames3948
@vanessajames3948 4 жыл бұрын
Aww, you're a life saver, thank you.
@enrikekasijas705
@enrikekasijas705 4 жыл бұрын
Excel is such a mistery xD thanks for the vid!
@PursueGodliness
@PursueGodliness 4 жыл бұрын
So is spelling 😂😇
@lilianmaeilano892
@lilianmaeilano892 4 жыл бұрын
Very useful tips, Thank You! 💪😊
@mohamedhaji2994
@mohamedhaji2994 8 жыл бұрын
Thanks for teaching us how to number the Excell.
@briantinkler
@briantinkler 5 жыл бұрын
Just saved me hours of work thanks!
@mhenghusain9866
@mhenghusain9866 2 жыл бұрын
This really helps me a lot , thank you so much🙏
@Mr.Steve-O
@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
@princessfloveecastillo2967
@princessfloveecastillo2967 3 жыл бұрын
thank you!! u just save my life
@compufama4678
@compufama4678 6 жыл бұрын
Excellent. You just saved my day today. thank you much
@donnatelosenobio5389
@donnatelosenobio5389 4 жыл бұрын
Thank you this is powerful tutorial. You save my time.
@nandinichinni8154
@nandinichinni8154 3 жыл бұрын
Thanks for Saving my time
@sunny1596
@sunny1596 4 жыл бұрын
Such a nice trick. Can I do this with date?
@mouniqua
@mouniqua 3 жыл бұрын
Your tips are very helpful! Thanks a lot.
@ammoniumdarapper6022
@ammoniumdarapper6022 5 ай бұрын
Thanks man, this is helpfully🌈
@cornkay2298
@cornkay2298 6 жыл бұрын
This was a very helpful tutorial. Thanks a lot 👌
Excel Fill Number the right way using the SEQUENCE function
7:07
Chris Menard
Рет қаралды 130 М.
7 ways to insert Automatic Serial Numbers in Excel
7:32
Datacense
Рет қаралды 22 М.
The Best Band 😅 #toshleh #viralshort
00:11
Toshleh
Рет қаралды 22 МЛН
The evil clown plays a prank on the angel
00:39
超人夫妇
Рет қаралды 53 МЛН
To Brawl AND BEYOND!
00:51
Brawl Stars
Рет қаралды 17 МЛН
PLEASE Learn This Underrated Python Feature...
14:30
Tech With Tim
Рет қаралды 7 М.
Data Entry using Form in Microsoft Excel | Data Entry in Excel
8:25
Excel Tips - Don't Use Formulas! Use Ctrl + E Instead
2:53
Career Solutions
Рет қаралды 1 МЛН
How to Autofill Dates in Excel (Quick and Easy)
4:01
Excel Tutorials by EasyClick Academy
Рет қаралды 84 М.
Most Useful Excel Keyboard Shortcuts
9:22
Technology for Teachers and Students
Рет қаралды 1,7 МЛН
Top 10 Most Important Excel Formulas - Made Easy!
27:19
The Organic Chemistry Tutor
Рет қаралды 8 МЛН
Создание сводной таблицы в Excel
11:26
Nikolay Pavlov
Рет қаралды 2,1 МЛН
How to Create Pivot Table in Excel
20:49
Kevin Stratvert
Рет қаралды 1,5 МЛН
The Best Band 😅 #toshleh #viralshort
00:11
Toshleh
Рет қаралды 22 МЛН