revps

Q: AUTOFILL NUMERICAL SEQUENCE

Numbers spreadsheet : How, please, do I autofill a single column in a simple numerical sequence starting from 1400 and going to 3000?

iMac (20-inch Mid 2007), iMac 24 inch 2008 OS X El Capitan

Posted on Sep 27, 2016 6:40 AM

Close

Q: AUTOFILL NUMERICAL SEQUENCE

  • All replies
  • Helpful answers

  • by Wayne Contello,Helpful

    Wayne Contello Wayne Contello Sep 29, 2016 6:02 AM in response to revps
    Level 6 (19,282 points)
    iWork
    Sep 29, 2016 6:02 AM in response to revps

    in the cell where 1400 resides, replace the contents with:

    =1400+row()

     

    Let's assume this is cell A2

    shorthand for this:

    A2=1400+row()

     

    select cell A2, copy

    select cells A2 thru the end of column A, paste

  • by Barry,Helpful

    Barry Barry Sep 29, 2016 6:01 AM in response to Wayne Contello
    Level 7 (32,502 points)
    iWork
    Sep 29, 2016 6:01 AM in response to Wayne Contello

    What Wayne says, with an amendment and some added detail

     

    For a simple numerical series that increments by 1 for each row, starting at 1400 and ending at 3000, you will need 1601 rows. Assuming one header row, with the series starting immediately below the header, the last row of the table will be row 1602.

     

    Start by using the Row control handle to extend your table downward until the last row is Row 1602.

     

    In cell A2, enter this formula:

     

    A2: =1400+ROW()-2

    Confirm the entry by clicking the green checkmark.

     

    Select cell A2. Copy.

     

    Click the column A reference tab (in the bar above the table) to select ALL cells in column A.

    Command-click on Cell A1 to remove it from the selection. Paste.

     

    Optional:

    If you want fixed values in this list, continue with these two steps:

     

    With all cells still selected, Copy.

    Go Edit (menu) > Paste Formula Results

     

    This replaces all formulas in the column with the last values calculated by those formulas.

     

    Regards,

    Barry

  • by revps,

    revps revps Sep 29, 2016 6:03 AM in response to Wayne Contello
    Level 1 (4 points)
    iWork
    Sep 29, 2016 6:03 AM in response to Wayne Contello

    Many thanks Wayne

  • by Wayne Contello,

    Wayne Contello Wayne Contello Sep 29, 2016 6:56 AM in response to revps
    Level 6 (19,282 points)
    iWork
    Sep 29, 2016 6:56 AM in response to revps

    Did any of the suggestions solve your problem?

  • by SGIII,

    SGIII SGIII Sep 29, 2016 8:51 AM in response to revps
    Level 6 (10,730 points)
    Mac OS X
    Sep 29, 2016 8:51 AM in response to revps

    Just fill in the first two cells of the sequence, then select the two cells, hover along the lower edge of the selection until a yellow dot appears, then drag the yellow dot down the column:

     

    Screen Shot 2016-09-29 at 11.47.18 AM.png

     

    Result:

     

    Screen Shot 2016-09-29 at 11.50.20 AM.png

     

    SG

  • by Wayne Contello,

    Wayne Contello Wayne Contello Sep 29, 2016 9:11 AM in response to SGIII
    Level 6 (19,282 points)
    iWork
    Sep 29, 2016 9:11 AM in response to SGIII

    for 1600 cells?

  • by SGIII,

    SGIII SGIII Sep 29, 2016 11:28 AM in response to Wayne Contello
    Level 6 (10,730 points)
    Mac OS X
    Sep 29, 2016 11:28 AM in response to Wayne Contello

    Wayne Contello wrote:

     

    for 1600 cells?

     

    Sure, why not?  Here's to row 3201.  Could easily have done it for far more cells.

     

    Screen Shot 2016-09-29 at 2.20.57 PM.png

     

    All you have to do is drag the = handle down at the lower left of table (pictured here just below the 3201) until you have enough rows in the table (you have to do something like that for a formula approach anyway.)  Then just grab the yellow dot and drag it down the column.  The Numbers table scrolls nicely.  Done in a second or so.

     

    SG

  • by Wayne Contello,

    Wayne Contello Wayne Contello Sep 29, 2016 1:02 PM in response to SGIII
    Level 6 (19,282 points)
    iWork
    Sep 29, 2016 1:02 PM in response to SGIII

    took about 10 - 20 seconds.

     

    Not bad.  I like my way better