5/14/12
7:42 am

Forum Question: How To Copy a Formula Into Multiple Cells

Hi Gary, I write about Numbers. I have a sheet with 6792 rows, but I want to copy a formula that is in row two to row 6791, as I can do it quickly?
thanks
regards
—–
Nelson Da Silva

Comments: 3 Responses to “How To Copy a Formula Into Multiple Cells”

    5/14/12 @ 8:14 am

    Just select the cell with the formula in it.
    Then select all of the cells you want to paste it into and paste. It will paste a duplicate of that formula into all of those selected cells, adjusted for each row.

    Dave
    5/15/12 @ 7:52 pm

    Is there a “copy” there somewhere?
    “Select” is so generic. You (Gary) might address “copy relative” vs literal, but that’s what the “Numbers Help” section is for.

      5/15/12 @ 8:32 pm

      For Nelson’s needs, just plain copy and paste will do it the right way.

Comments Closed.