6 Replies Latest reply: Aug 11, 2007 8:25 PM by Folklorist
Folklorist Level 1 Level 1 (5 points)
I've never been a big spreadsheet user but I recall being able to intuitively (the only time ever with a MS product) find a way to duplicate a row or column in Excel so that it would replicate the same formulas as the row/column immediately adjacent to it. Can this be done with Numbers?

Example: Say I've got a row that has values across with a Sum Total cell and an Average cell calculated with formulas. I'd like to add other rows below so they inherit the same formulas (referencing cells in the new rows). I'm already getting irritated just thinking about having to assign formulas over and over again with each new row.

I hope I'm just missing something obvious.

CA

PowerBook G4, Mac OS X (10.4.10), new Numbers user, 1.2 gb ram