Paste and increment cells in numbers

Discussion in 'Mac Basics and Help' started by rpoland, Jan 24, 2016.

  1. rpoland macrumors newbie

    Joined:
    Mar 31, 2012
    #1
    In Numbers 3.6.1, )S 10.11.3,
    I want to enter in cell 1 a 1 then moving down enter a Space then moving down enter a 2then moving down enter a space.Then select these four cells and drag them down duplicating and incrementing into many cells. This operation works in Excel but NOT? in Numbers? Or is there a way?
     
  2. dan1eln1el5en macrumors 6502

    dan1eln1el5en

    Joined:
    Jan 3, 2012
    Location:
    Copenhagen, Denmark
    #2
    that behavior in excel is the same in numbers, you just forgot how to do it ;)

    type in 1, 2, 3 then mark the three and drag the outline (lower right corner) and the then the following cells will become 2, 3, 4... (You can use the same for dates and also if you have a pattern, e.g. 1,3, 5 will result in 7,9,11 and so on)

    if you want automagically, like you described, then you have to format the cells to understand that they contain unique identifiers something like "=cellAbove+1"
     
  3. Weaselboy Moderator

    Weaselboy

    Staff Member

    Joined:
    Jan 23, 2005
    Location:
    California
    #3
    That is not how this works in Numbers.

    OP... enter 1, 2, 3 then select the three cells, then grab the yellow dot in my screenshot (not the corner) and drag it down.

    Screen Shot 2016-01-25 at 10.08.09 AM.png
     
  4. dan1eln1el5en macrumors 6502

    dan1eln1el5en

    Joined:
    Jan 3, 2012
    Location:
    Copenhagen, Denmark
    #4
    ah ok, thats what I meant, was sitting at a Windows machine when writing
     
  5. Weaselboy Moderator

    Weaselboy

    Staff Member

    Joined:
    Jan 23, 2005
    Location:
    California
    #5
    Heh... for sometime I was using Windows at work and OS X at home and it made my head hurt. Not so much that one was better than the other, but just remembering how to do things differently on each machine was a pain. :)
     

Share This Page