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
MacMost Q&A Forum • View All Forum Questions • Ask a Question
How To Copy a Formula Into Multiple Cells
Comments: 3 Responses to “How To Copy a Formula Into Multiple Cells”
Comments Closed.
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.
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.
For Nelson's needs, just plain copy and paste will do it the right way.