Excel - AutoFill Thousands of Rows at Once in Excel

What if I want to add 2500 then 2600 in the series then how ????

Thank you

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

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

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

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.

Thank you
It helped me lot :)

Very helpful

I want to do this but with just the same value

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!

Great Video. thanks

How about we replace the same number with the same formula

THANK YOU!!!!!!!!

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

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.

Thanks

very helpful, thanks a lot. :)

It does not work on tables, is there an easy way to do this in a table? Thanks

Thank you.....

can we script this? like I enter a value and automatically a column of that size is created? enter number 5, a column of 1,2,3,4,5 created

The newer excel versions have altered the 'buttons'

Thank you so much

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

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

Thanks and I just want to say I tried this tactic with Google Sheets and it also WORKED!!! You Saved Me...

It does or doesn't fill formula?

I want to format several thousand cells in a column, but I don't want to select the entire column because that caused issues before if I had to insert something.

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

Great! thanks

Is something similar possible in the online version? I can't see that button.

Thanks, this helped a lot!!!

i actually am in openoffice and i get the same window as you and can set the data range in the series tab..but i would have to manually slect the cells and ..so for 1 000000 i have to selct 1million cells....how do i get aroundd this ..thxz

Can you do this with a formula? Like if i want to fill a formula in 10000 rows/columns?

Thank You...

Great :-)

Thank you so much. It's useful

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

Add Jet Reports and you get Excel on steroids!

Why start with number 1? What would happen if you started with different number?

>with a click of a single button
You clicked 10 buttons.

Thanks a lot! Very useful.

I have a question but I'm not sure how to word it properly to explain so bare with me.
I'm trying to make a spreadsheet for my investing and I have all the columns figured out except for one. The first column is my initial investment the next is * the percentage rate, the next equals my daily payout that I receive.
What I'm trying to figure out now is when I'm doing my reinvesting, my last column, I'm only going to do it in multiples of $100 dollars or greater but to the highest power of 10 so if it's $109 I want the column to automatically take out 100 and add it to the First Column for reinvesting and so on so forth always do the highest 10 but greater than $100 no less. Can you help?

thanks a lot mate
u saved my day

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

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.

Thank you

hi may i know the presentation , what software u using?

Thanks for the tip, very helpful

Thank youuuU!!!!