Excel - AutoFill Thousands of Rows at Once in Excel

This tutorial shows you how to fill thousands of rows or columns with incremental numbers or dates with the click of a button. You will learn multiple ways to quickly fill-in the data, but, you will also learn the quickest way to do so. For instance, this Excel tutorial will show you the easiest way to fill-in 10,000 (or even a million) rows with numbers starting from one; the method illustrated is much faster than the alternatives outside of VBA.

[EliMillerFL]

Been looking for this for 20mins and so easy once I found your video. Thank you!

[spaces]

I needed this shortcut. I run into this problem a lot. Thank you.

[wenrdeh]

Thank you very much for the details! There are many videos about how to do drag and drop, but many skipped the basic steps, especially for very very new beginners. Thanks again!

[pauls]

Thanks. I just did 2500 lines the hard way. At least I know for the future!! Cheers.

[MichelleAyana]

You just saved me from numbering 100k+ data by dragging it lol.
Thank you ❤

[davethomas]

Thank you... You just saved me hours of work...

[eman]

How would you auto fill one word like "Unknown" from A1 to A10, 000?

[Danylo_Buhaievskyi]

BINGO! I found what I was looking for for a while!! thank you, fam!!

[bejoyvm]

Can I have the "Stop value" reference a cell, so that whenever I enter a quantity/number in that cell, my column would auto fill to that number i entered in my designated cell.

[combofriend]

does anyone know how to do this, but with arbitrary text before the number? Like the same way excel can do that if you highlight and drag a cell that has text ending with a number, and will increment the number part by default- but without having to drag so you can do a really large value fast.

[skmr]

Thanksss a lot, this is very helpful for me who is very beginner in excel!!

[mehmetdogu]

how do you put 0's in 10000 rows. this formula does not work?! there are ways but like to work it easy way. by the way, you are good.

[mashfiqulislam]

That's really great! Thank you so much!

[digitalbreakthroughs]

Great Excel tip. I just added this video to one of my playlists. Thanks for sharing.

[reaperqnu]

Hi what if we need to fill a range of cells with a formula

[compunerd]

This is decent, but it doesn't fill formulas for you.

[baronmordo]

How about we replace the same number with the same formula

[jt]

How do you do this if there are hidden rows

[Ritvej]

Thanks a lot your tutorial was a great help for me. It was great learning.

[manzarek]

Hi, i wonder if you can increment to a certain value from another cell. If you type 10 than the cells generate 1, 2, 3 and so on until 10. If you change 10 to 5 than you get max 5 numbers genersted.