Excel question

[quigleybc]

Hi

I have to input thousands of numbers into a single excel spreadsheet column starting at the top and working my way down. is there a way to drag/copy the original number "1" and have the cells below go up by 1 each time? 1, 2,3 ect.

I think I've seen this done before....

Any suggestions?

Thanks

 

[MacDawg]

Enter 1 in the first cell and 2 in the second
Select both cells
Drag from the right bottom corner down

Woof, Woof - Dawg

 

[mpw]

Enter 1 in the first cell and 2 in the second
Select both cells
Drag from the right bottom corner down

Woof, Woof - Dawg

What he said, and it works if you put Monday in the first cell Tuesday in the second and drag you'll get Wednesday, Thurs....Sunday, Monday etc.

Likewise put 1st, 2nd and it'll continue the sequence. Excel is an awesome app. there are many more pre-entered lists and you can even enter a list that maybe you use all the time, like employees names, and just enter the first name and drag to complete the list.

 

[MacDawg]

Excel is an awesome app. there are many more pre-entered lists and you can even enter a list that maybe you use all the time, like employees names, and just enter the first name and drag to complete the list.

Preferences > Custom Lists

Woof, Woof - Dawg

 

[quigleybc]

You guys are great!

Thanks very much for your prompt reply's and helpful tips!

much appreciated...

 

[clayj]

Another possible solution (one that's more dynamic) is to enter the formula "=ROW()" in the cell, and then fill down. This formula will return a 1 in any cell in row 1, a 2 in any cell in row 2, etc. You can modify the formula with a + or -, like this:

=ROW()-1

=ROW()+2

to modify the returned value. There's a corresponding COLUMN() function that does the same thing for columns: 1 for column A, 2 for column B, 256 for column IV, etc.

And of course, you can embed the ROW() and COLUMN() functions inside formulae.

Excel is like Legos... there's almost nothing you can't do with it.