3 Replies Latest reply: Apr 19, 2013 12:33 PM by pini haka
pini haka Level 1 Level 1 (0 points)

Hi having a problem when I try to copy text in a cell and drag it down to copy to other cells in a column.   If I enter a number it will copy this but if I enter a letter and a number it increase the number. I am trying to copy the code cs600 and copy it to multiple cells but it keeps increasing the number 600 601 etc.  If I just put in 600 it just copies the number and does not incease it.

 

Cheers


MacBook Pro with Retina display, OS X Mountain Lion (10.8.3)
  • 1. Re: Numbers Autofill
    Yellowbox Level 5 Level 5 (4,565 points)

    Hi pini haka,

     

    Instead of dragging down, use a temporary formula. If cs600 is in Cell B2, enter =B2 in Cell B3

     

    Drag to fill B3 down.

     

    Select B3 and those newly filled cells, Edit > Copy then Edit > Paste Values. That will replace the temporary formulas with the values.

     

    Regards,

    Ian.

  • 2. Re: Numbers Autofill
    Barry Level 7 Level 7 (29,180 points)

    An alternative to Ian's suggestion: Use Copy&Paste.

     

    Enter cs600 in the first cell and confirm the entry by pressing return or tab.

    Click on the cell to select it.

    Copy (command-C)

    Drag to select the rest of the cells. Ignore the incremented values that are filled as you do this.*

    Paste (command-V).

     

    *If you are filling many cells, you may also select the range by clicking on the first cell, then shift-clicking on the last cell in the range.

     

    Regards,

    Barry

  • 3. Re: Numbers Autofill
    pini haka Level 1 Level 1 (0 points)

    Thanks Barry this solved the problem

    Cheers