How To Fill Numbers In Excel Quickly And Easily!

[@chadbullard979]

Thank you, wished I had seen this 17 years ago. Wasted a few minutes setting up numbering math formula, this way in video is so much easier and faster.

[@creativitywithsomefun1614]

Just use =SEQUENCE (range of numbers) E.g. =SEQUENCE(1000), gives you a list of numbers from 1-1000😊 though this is also really easy shortcut THANK YOU ❤❤

[@leavesofthetreehealing3211]

I was trying to "fill series" for sequential numbers but didn't see that option. It told me I had to grab a few cells of the series to get an idea of what I wanted it to fill the rest of them with. I was able to do that and figure it out thanks to this video. The video was extremely helpful and saved me time. Thanks again.

[@datadreamsit8514]

can you share with the class?

[@PanagiotisNestoras-d7h]

Thanks a lot! Straight to the point . Earned yourself a like !

You are the lifesaver!!!!

[@AnisNabihahAhmadZaini]

THANNK YOUUUUU QUICK EASY AND STRAIGHT TO THE POINT:)

[@acrobatstar]

Thanks a lot brother god bless you my boss didn't know how to explain it and i was struggling

[@nieshpalmore]

Thank you so much ❤ I spent minutes trying to figure this out & ur video took me no time 🎉

[@ExcelCampus]

Glad it helped, @nieshpalmore7976! 😀

[@muntaser1988]

hello Mr campus please help me get hero tools @excelcampus

[@Nozy_Otter]

Double left click for the win! Thank you, had more than 10k rows to fill, filled in seconds

[@michaeldruce4536]

Thanks Jon. Your knowledge is invaluable. Thank you ☺️

[@ExcelCampus]

You're welcome! 😀

[@MrDarkogaucho]

You are a life save. Thank you very much and you just got new subscriber in me

[@ExcelCampus]

You're welcome! 😀

[@MrDarkogaucho]

@@ExcelCampus I do have a question if you don’t mind. Is there a shortcut key to achieve the double clicking to fill the bottom rows without exceeding the last row? Thank you very much in advance?

[@TyeGrays]

game changer on how to copy LOL thanks!!

[@TayyabAshiq-ln8xg]

Thanks for the nice video😊😊 it's very helpful😊❤❤❤❤🎉

[@ExcelCampus]

Glad it was helpful, @TayyabAshiq-ln8xg 😀

[@TayyabAshiq-ln8xg]

@@ExcelCampus l am also happy 🤗😀😊😊

[@jonathantienter6874]

Saved my sanity! 🎉

[@martinjurik6067]

maaaaaaaaan!!!!! that´s so coool I knew there must be a way !! thank you!! you earned subscriber!

[@ExcelCampus]

Thank you, Martin! 😀

[@CDeeez94]

Thanks for the tips!

[@ExcelCampus]

You're welcome! 😀

[@shivanimaurya3773]

Really Helpful ❤ thanks a lot 🎉

[@ExcelCampus]

You're welcome 😊

[@zellrang]

Fast and straight forward explanation so thanks

[@ExcelCampus]

You're welcome! 😀

[@dfo490]

Thank you so much got sent to do some stuff for excel and in a bit rusty thank you so much

[@DiogoGDF]

Thank you! Straight to the point!

[@AndreaR-wq8dh]

Extremely helpful, thank you.

[@ExcelCampus]

Glad it was helpful! Thanks, Andrea! 😀

[@mariatjali7432]

thank you very much you helped me a lot

[@ExcelCampus]

Glad I could help! 😀

[@suhelgaming3644]

Good job, really workable

[@ExcelCampus]

Thanks! 🙂

[@RakibSUST]

Thanks man,i Learn data science since 1 year but Don't know these double click shortcut

[@ExcelCampus]

Happy to help. 😀

[@carlosjosedominguezleonard1837]

Helped a lot just now❤😂

[@ExcelCampus]

That's good to know, Carlos! 😀

[@ZaneleMondi]

Thank you just used it and it worked. awesome

[@ExcelCampus]

Glad it helped, @ZaneleMond! 😀

[@Yunidude]

Great video, thank you!

[@ExcelCampus]

You're welcome! 😀

[@abdemalekabde64]

Thank you bro, a lot

[@Cha-yt3qi]

Thank you❤

[@ptoktedia9011]

thank you sir this video is very helpful

[@ExcelCampus]

Thanks for watching, @ptoktedia9011 ! 😀

[@alexsnagz6473]

Thank You!

[@ExcelCampus]

You're welcome, @alexsnagz6473! 😀

[@LovePeace-wy1ii]

Thank you, I've been searching everywhere.

[@FHAZGAMING1]

Same Thank you

[@cricketskingdom3591]

Thanks man....love from India 🎉❤

[@prasanthjoel1463]

thank you so very much. its very helpful...

[@ExcelCampus]

Glad it was helpful! 😀

[@ALECxDAxMAN101]

I love you!

[@vedang6]

thank u very much

[@ExcelCampus]

You are most welcome! 😀

[@kamaboko1]

What if you need a fill for a column that is like 2000 rows. Is there a shortcut for that, or do I have to drag all the way down?

[@ExcelCampus]

Great question! 😀 Yes, you can double-left-click the bottom-right corner and it will fill all the way down to match the other column's data. Check out the 0:18-0:20 mark in the video. If you need the numbers to increase, check out the 0:30-0:34 mark in the video. I hope that helps you! 😊

[@ginnyhuang2187]

It really helped out

[@ExcelCampus]

That's good to know, Ginny! 😀

[@everlynSimon-ye1yo]

Very easy thanks much

[@ExcelCampus]

You're welcome! 😀

[@YAHAYATH786]

Thanks ❤

[@biniamhaddis4870]

Thank you.God bless you.

[@filipe5153]

Is it possible to set Excel to autofill a collumn everytime I add a new line?

[@abdulrahmanmuslih141]

Awesome. Thanks

[@ahmadhatami6906]

Thank you somuchh

[@ExcelCampus]

Welcome, @ahmadhatami6906! 😀

[@c.sam3843]

Does it work on google sheets too? I can't find the autofill option like you did in the video.

[@savagemaster344]

How to fill the cells with same number using the keyboard or shortcut keys, and not the mouse by doing double click. I want to try to keep my hands on the keyboard ad much as possible.

[@BeathaAugustina-v3i]

Thanks alot god blss you

[@salesobspltd3346]

thank you sir

[@RahulVaishnav-f3o]

Is there any shortcut of that + sign at the corner of the cell.....and I am not talking about Ctrl D....I don't want to select any area but still want to fill the series without using mouse

[@ExcelCampus]

Nice question! Difficult without selecting an area. Consider converting the range to a table (Ctrl+T), then selecting the entire column (Ctrl+Space). Use Alt+H, F, I ("eye", not L), S. That gets you to the Fill > Series menu. You can either go with the step value listed, use tab to navigate the options, or choose Alt+T to jump to the Trend box. Lastly, press the Enter key. This may not work for your specific case, but it avoids using the mouse.

[@crisp1066]

Trying to put sequencial numbers in a colum. Tried your method 5 times but only get a "Quick Analysis" icon at the bottom right cell. 😡

[@adamscott811]

great

[@shushanthG456]

Tq bro

[@aliciacatherineegan]

🔥🔥🔥

[@mtlwgm]

Is there any keyboard shortcuts instead of double clicking?

[@cricketskingdom3591]

Yes, Alt+E+I+S

[@richabaranwal8005]

Helpful vdo

[@ExcelCampus]

Thank you 😊

[@Deanamite]

how do you fill starting from under to the top ? in example 1 is at the bottom but you want 10 on top

[@ExcelCampus]

Great question, Dean! One way is to fill 1-10 as shown, then Sort the selection from Largest to Smallest. That will reverse the order. Then, re-apply 1-10 as shown from top to bottom and re-sort if desired. Another way without sorting would be to enter 10 at the top, then from the Ribbon choose Home > Editing > Fill (down arrow) > "Series...". Change "Series in" to Columns, the step value to -1, and the stop value to 1, then select OK. Hope that helps!

[@helenatogo9057]

What if the option auto fill series is not an option, how would you get around this?

[@gustavballieuwiesneckgarno3313]

Can you drag down numbers without using the mouse though?

[@happyandwonder7582]

How to auto change number? For example 123, change to 132, 213, 231, 321, 312 like this Please help

[@cjnavales1010]

how to fill in series numbers backward as you start with #130 to #1. hope you notice

[@ExcelCampus]

I noticed, CJ! 😀 Use the SEQUENCE function, available in newer Excel versions. =SEQUENCE(130,1,130,-1) yields 130 rows, in 1 column, starting at 130, going backward by 1 ("-1"). Sequence: kzbin.info/www/bejne/ipSpl5mahceHnLc&Also, Fill Series (Alt+H+F+I+S) with Trend checked and a Step value of -1 would work. Fill Series: kzbin.info/www/bejne/a5KcmHqeh9uZotk& Hope that helps!

[@Pasdpawn]

Whats the shortcut keyboard though?

[@ArthurParada]

i wonder too

[@Pasdpawn]

@@ArthurParada ctrl+ D

[@ArthurParada]

hahahah @@Pasdpawn

[@Pasdpawn]

@@ArthurParada yes it is

[@Xman-lg7qg]

Any way to do the same reading from another sheet.

[@dennisshanley71]

weird how the online EXCEL version used in SHAREPOINT will not even sequence fill after telling it to do so...

[@sankamil4876]

How to unlock the double tap feature? It doesn't work on my device

[@BharathKumar-tt1ox]

How to make one perticular name for one specific number with auto fill

[@w3y2023]

in excel how add mark"+" then add 1 ? thanks

[@vladimir7759]

0:22 I've been at Excel for 8 years, but I only found out about it now lol

[@deheiligebron]

I just stood up and made a little dance!

[@paulstephenelogronio7088]

❤

[@bloodtypena]

There is no fill series button

[@helenatogo9057]

I know right, I use to be able to do the way he is showing us but now that option isnt there and is replaced with Copy Cells, Fill Format, Fill without Format and Flash Fill 🤯🤯🤯

[@youngerin5768]

I literally just threw my hands up in success lol.

[@vikramnagarajan7]

❤👍

[@allfurone]

I don't get the "fill series" option.

[@HotspurFC-cu6ny]

How do I do this on a MacBook

[@sadafmahadi4033]

Can it be done? A1 A2 A3 A4 B1 B2 B3 B4 C1 C2 C3 C4 An so on

[@ExcelCampus]

Yes, this list can be created with a Formula. We'll add this question to our list for future videos. Thanks!

[@skillpro00000]

this is a simple way but almost nobody concern.

[@koujipajenago9159]

What if i Want 00001,00002?

[@ExcelCampus]

Great question, Kouji! Use an apostrophe, ' , in front of the entry to indicate text. After typing '00001, Enter, '00002, Enter, select the first two cells. Then, drag the bottom-right corner down as far as you need it to go!

[@rjkuttu]

Thankyou🫶🏻

[@ExcelCampus]

Welcome 😀

[@khurramtalks1]

9 is not an odd number 😂

[@rexbk]

Thank you!

[@ExcelCampus]

Welcome! 😀

[@everlynSimon-ye1yo]

Very easy thanks much ,

[@ExcelCampus]

Thank you too! 😀

[@bernardeshun2289]

THANKS BUT MINE IS NOT WORKING WITH ODD NUMBER AND EVEN NUMBERS