How do I duplicate row or column with formulas?

Question

Level 1

12 points

How do I duplicate row or column with formulas?

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

Posted on Aug 11, 2007 3:19 PM

Reply

Answer 1

Aug 11, 2007 7:47 PM in response to Folklorist

There is a duplicate command under the Edit Menu item. The short cut is the apple key and "D". However, I have the trial copy and it is grayed out. Meaning it is not working. I have my bought copy arriving next week. Hope this is not grayed out in the bought version. This is a deal breaker. I use this command all the time. They need to fix this right away.

Reply

Answer 2

darrenv

Level 2

199 points

Aug 11, 2007 7:51 PM in response to Mr. Propulsion

It is definitely grayed out. Feedback.

Reply

Answer 3

Peggy

Level 8

41,595 points

Aug 11, 2007 8:01 PM in response to Folklorist

I did a search in Numbers Help for "duplicate." I believe the Duplicate command is for duplicating any objects. You could duplicate a whole table but not columns or rows.

Reply

Answer 4

Folklorist Author

Level 1

12 points

Aug 11, 2007 8:04 PM in response to Peggy

Right, I've seen the Duplicate command but, as Peggy says, it doesn't apply to duplicating rows or columns (with or without formulas).

Still hoping someone can clue this knucklehead in. . . . Hope springs eternal!

Reply

Answer 5

Aug 11, 2007 8:20 PM in response to Folklorist

I do this all the time in Excel, too.

Try this. Click once on the column heading, i.e. "C" for column C. Hit command-c to copy. Click once on the destination column heading, i.e. "D" for column D. Hit command-v to paste. Seemed to duplicate the column for me, along with formulas.

Works for rows, too.

Reply

Answer 6

Folklorist Author

Level 1

12 points

Aug 11, 2007 8:25 PM in response to David Firth

Thanks DF! That's great. As I suspected (feared) it was something bald simple and obvious. I appreciate the time you spent posting--it'll save me and others way more time in return.

Cheers.

CA

Reply