copying cell sizes / cell formats to a new table

Question

copying cell sizes / cell formats to a new table

Hi,

I created a complicated formated table in numbers with cells in all different sizes (height and width) and colors.

I want to paste and copy part of that table to a new sheet.

1. It seems impossible to simply create a new table WITHOUT any formats and alternating cell colors (Seriously?...)

2. When copying the cells to the new table/page all formats concerning the size (width and height) of the cells are lost. Surely there must be a way to keep the initial formatting.

Thanks for the help guys.

Peter

iPod touch, iOS 5.1

Posted on Jan 9, 2014 7:18 AM

Reply

Answer 1

Jan 9, 2014 8:19 AM in response to Struwwwelpeter

Why not try duplicating the complicated table and remove the extra stuff from the duplicate?

Reply

Answer 2

Badunit

Level 7

30,924 points

Jan 9, 2014 8:32 AM in response to Struwwwelpeter

You are correct that cell height and width are not retained in the paste. Pretty much everything else is, though. I can see wanting the column or row size to change some times but I also can see times I wouldn't want that.

If you want to copy an entire row or column, complete with all formats and sizes, you can drag an entire row or column to another table. Use Option when dragging to create a copy vs moving it.

Apple does seem to like alternating row colors for the default table styles. You can turn them off pretty easy, though. You can create a table with or without headers. There is no such thing as "without any formats". What exactly do you want?

Reply

Answer 3

Yellowbox

Level 7

21,951 points

Jan 9, 2014 8:08 PM in response to Struwwwelpeter

Hi Peter,

It seems impossible to simply create a new table WITHOUT any formats and alternating cell colors (Seriously?...)

I have this as a custom template in Template Chooser. It is my default for a new document.

Regards,

Ian.

Reply

Answer 4

Jan 10, 2014 6:28 AM in response to Wayne Contello

Hi,

yeah, totally. But I need to copy parts into one.

Thanks for the idea, though. :-)

Reply

Answer 5

Jan 10, 2014 6:31 AM in response to Yellowbox

Hi Yellowbox,

that´s exactly what I ment. It´s formated to have a header and a side column. And the cells are in a different color. And god only knows, what else is contained in the formating. I want a clean virgin table, clean like fresh snow. :-)

Greetz

Peter

Reply

Answer 6

Jan 10, 2014 6:44 AM in response to Badunit

Hi Badunit,

what I am doing is trying to move part of a Table with all different cell width to another page. I keep losing the cell width which is realy annoying since it took me hours to set all the different cell width. I worked with Excell before and copying and retaining cell width and height was not a problem. So I´m pretty baffled that something simple as this can not be done with numbers. Shouldn´t there be something in the context menu like "Paste and keep layout" or smt like this?

Anyway thanks for the hint about drag & drop. That works quite well. I draged and dropped the part of the table on the same page and afterwards moved it to a new page. It shouldn´t be like having to do this in a two-step-procedure, but it´s a good workaraound.

Thanks a lot!

:-)

Reply

Answer 7

Yellowbox

Level 7

21,951 points

Jan 10, 2014 7:07 AM in response to Struwwwelpeter

Hi Peter,

I want a clean virgin table

Like this?

Likewise with Header Columns > 0

And god only knows, what else is contained in the formating.

Just 1 point cell borders in black 😉.

Easy peasy!

Regards,

Ian.

Reply