Copy and pasting a row into a new sheet in Numbers

Have you tried selecting the row, holding the option key down, and dragging? (so it "lifts" and drops between rows in a new location in that table or another table).

That will create a duplicate with the same dimensions.

SG

Do you mean another table or another sheet?

You can definitely drag to another table on the same sheet.

And you can even drag to another table in a different document.

It is impossible, of course, to drag from a table on one sheet to a table on another sheet because you have only one "window" on a document at a time.

You can click in a table, click the "bulls-eye" its upper left, command-c to copy, navigate to a different sheet in the same document and command-v to paste the table. Then drag from the copied table to wherever you want it on that sheet.

SG

> I'd have thought that table & sheet the same.

Nope. Not in Numbers. That's an Excel thing, where a 'document' contains multiple 'sheets', where each sheet is a (potentially massive) grid of rows and columns.

In Numbers, a 'document' is a collection of 'sheets', and each sheet can contain any number of distinct 'tables', where each table is a grid of rows and columns.

So in Numbers, it's entirely possible (and common) to have a single 'sheet' that contains multiple 'tables'.

Any cell can reference any other cell in the same table (e.g. '=B4'), in another table on the same sheet (e.g. 'Table Name::B4'), or in another table on a different sheet (e.g. 'Sheet Name::Table Name::B4'), but Numbers won't let you reference cells in a completely different document.

If you want, you can have one table per sheet and mimic the Excel way, but it all depends on how you want to slice and dice your data.

To confuse things further:

A "worksheet" in Excel corresponds to a "sheet" in Numbers (each has a "tab").

But a "worksheet" in Numbers is akin to a "workbook" in Excel. Also known in both apps as a "document."

And Excel has "tables" too! You could in theory put more than one of them in a worksheet. But the big grid of cells integral to every Excel worksheet makes that awkward so it is probably seldom done.

Placing multiple tables on a sheet in Numbers, by contrast, is natural and easy, and can achieve results difficult reproduce in Excel. For an example see the 'Calendar' template at File > New in the menu.

Anyway, in Numbers think document > sheets > tables (and charts and other objects).

SG

New table on same sheet is easiest.

New table on new sheet in same doc is harder

SG