Excel basic question

[alintatoc]

Can somebody tell me what is the combination to create a column from one to 1-100, without introducing it manually?

Here is what I mean:



Uploaded with ImageShack.us

Thanks in advance!

[poisondeathray]

Do you mean autofill the value "1" from rows 0-100 in column 1?

Select the cells, you only need 3 filled in with "1" for it to work (i.e marquee select the area ) , then move cursor to bottom right hand corner of that selection area, a "plus" sign will appear, hold left click and drag all the way down to row 100

It will autofill patterns too. So if you had 1,2,3 , it will fill in 4,5,6, etc...

[alintatoc]

Do you mean autofill the value "1" from rows 0-100 in column 1?

Select the cells, you only need 3 filled in with "1" for it to work (i.e marquee select the area ) , then move cursor to bottom right hand corner of that selection area, a "plus" sign will appear, hold left click and drag all the way down to row 100

It will autofill patterns too. So if you had 1,2,3 , it will fill in 4,5,6, etc...

Thank you very much!

Cheers!