Excel question

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

  1. quigleybc macrumors 68030

    quigleybc

    Joined:
    Jun 17, 2005
    Location:
    Beautiful Vancouver British Columbia, Canada
    #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

    MacDawg

    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 [​IMG]
     
  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

    MacDawg

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

    Woof, Woof - Dawg [​IMG]
     
  5. quigleybc thread starter macrumors 68030

    quigleybc

    Joined:
    Jun 17, 2005
    Location:
    Beautiful Vancouver British Columbia, Canada
    #5
    You guys are great!

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

    much appreciated...

    :D :D
     
  6. clayj macrumors 604

    clayj

    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.
     

Share This Page