# Excel question

Discussion in 'Mac Apps and Mac App Store' started by quigleybc, Oct 18, 2005.

1. ### quigleybc macrumors 68030

Joined:
Jun 17, 2005
Location:
#1
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

2. ### MacDawg macrumors P6

Joined:
Mar 20, 2004
Location:
"Between the Hedges"
#2
Enter 1 in the first cell and 2 in the second
Select both cells
Drag from the right bottom corner down

Woof, Woof - Dawg

3. ### mpw Guest

Joined:
Jun 18, 2004
#3
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.

4. ### MacDawg macrumors P6

Joined:
Mar 20, 2004
Location:
"Between the Hedges"
#4
Preferences > Custom Lists

Woof, Woof - Dawg

5. ### quigleybc thread starter macrumors 68030

Joined:
Jun 17, 2005
Location:
#5
You guys are great!

much appreciated...

6. ### clayj macrumors 604

Joined:
Jan 14, 2005
Location:
visiting from downstream
#6
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.