MacMost Q&A Forum • View All Forum QuestionsAsk a 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”

    12 years ago

    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
    12 years ago

    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.

      12 years ago

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

Comments Closed.