Fill down the whole column with consecutive numbers without dragging the mouse

**pcsjes** · 12-14-2012, 04:07 PM

How are you all?

This is my first posting in this forum.

I am just wondering how I can fill up the whole column with consecutive numbers.

I know how to do it for small numbers such as 100, 1000, or even 100,000 by dragging down the mouse.

However, if I want to do it up to the end of the column, which is more than million (exactly 1048576), it takes me not only time but my breath and endurance.

Would anyone can show me how to do that with a small number of typing at once, say, by macro such as {fillup(A01:A1048576)}???

I appreciate your help in advance.

Thanks.

**Moo the Dog** · 12-14-2012, 04:12 PM

Enter a 1 in cell A1, select cell A1 and hit Ctrl + Shift + Down Arrow
Click on FILL, choose 'Series' with a step value of 1.

- Moo

**Norie** · 12-14-2012, 04:13 PM

This will fill down 10, 20, 30... to the last row.

Please Login or Register  to view this content.

**icestationzbra** · 12-14-2012, 05:39 PM

highlight the entire column, enter a formula in the formula bar and hit CONTROL+ENTER.

for example, click on column label A. once the entire column is highlighted, go to formula bar and enter the formula:

=ROW()

while the cursor is still in the formula bar, hit CONTROL and ENTER together. in a couple of seconds, the entire column A will be filled with 1, 2, 3, 4, 5...

if you wanted to fill 10, 20, 30, 40, 50 etc., you would use the formula:

=ROW()*10

if you want to fill 1, 2, 3, 1, 2, 3 etc., you would use the formula:

=MOD(ROW(),3)+(NOT(MOD(ROW(),3))*3)

basically, any sequence or progression, which can be represented mathematically, can be established using this method.