Insert copied rows formatting

For what you want to do, I think Wayne gave the correct answer. Paste and Match Style will paste the data into existing rows in the destination table while maintaining the formatting of the cells in the destination table. But it matters what you have selected before you do it.

If you click on a row number to select a single row, when you Paste & Match style (or just Paste) it will only paste only the first row. If there are an insufficient number of columns in the destination table, it will not add new columns

If you select a range of row numbers to select multiple rows, it will paste into the selected rows. If you selected too many rows, it will start repeating. If there are insufficient columns in the destination table, it will not add new columns

If you select a single cell in the first column of the top destination row, it will paste everything, however many rows you copied. If there are not enough rows in the table rows, it will add more to the bottom. If there are not enough columns, it will add new columns. Everything will be pasted.

The last one is the best way. Note that all of these assume you will be pasting into empty rows, though the last one will add new rows to the bottom of a table if necessary

I tried rows with bold, italics, larger text size, thicker borders, different cell background color, different text color and one row that was default text except I made the row height larger. The only format that did not transfer over for me was the larger row size. I am not finding a way to get the larger row size to transfer over.

If the tables are on the same sheet, you can drag-drop the rows:

1. Select the range of rows
2. Click and hold on one of the row numbers until the rows lift from the table
3. Press the Option key to make it copy rather than move them. Skip this step if you want to move them.
4. Drag and drop on the other table.

This works best/easiest if the source and destination are both in view or not too far of a scroll away. It cannot be done across sheets.

I don't know if this will be of use but here is a way to get it to another sheet:

1. Select a range of rows
2. Copy
3. Go to another sheet
4. Paste into a blank place on the sheet to create a new table
5. Add at least one new row to the table
6. Use the method above to move the rows to another table
7. Delete this temporary table.

Certainly not as easy as "Insert copied rows" but it might be easier than redoing a lot of formatting each time (though, other than row height, I did not have a problem with formatting).

I suggest copying the rows, then

Insert additional rows into the target table, then select the first cell of the new, empty rows

you may insert additional rows using the key combination <command>+<down arrow>

to add multiple rows, select the rows, then use the key combo (up or down arrow for after or before)

select the first cell of the new rows (NOT The row, then left-most, first cell),

then use Paste and Match Style.

try the Numbers menu item "Edit > Paste and Match Style"

"Without any luck" means what?

The ability to lift columns/rows from a table and relocate them is a very handy thing to be able to do. If that was what you had no luck with, it is something you might want to learn how to do anyway.

But if "without any luck" means it still did not copy the formatting and row heights, I am confused. i'm already confused as to why no formatting is copying over for you with "insert copied rows" when all work for me other than the row height. Are you running an older version of Numbers? I only have the latest to test with.

I obviously misunderstood. I thought you wanted the formatting of the copied rows to persist, not take on the properties of the new table.