Numbers 3.1 - erases content of cells when using copy and paste

Hide the columns that you don't wish to copy before making the selection and copying. Paste while the columns you do not wnat to paste into are still hidden. Hidden columns will not be copied and hidden columns will not be pasted into or affected in any way. When done, unhide all columns.

Jerry

While not as easy as selecting just cell C8 before you paste, if you select cells C8, E8, G8, I8 etc. before you paste it will not erase the other cells.

Badunit,

In my test, it does erase (blank) the other cells.

Jerry

Jerry,

We must be doing something different.

First screenshot I choose cells B2, D2, F2 then Copy

Second screenshot I choose cells B3, D3, and F3

Third screenshot I Paste

Badunit,

I see the difference. I didn't do a selection before the paste. I assumed that the non-copied cells would skip cells in the paste, and found they don't.

In Numbers '09, it wasn't necessary to make the selection the for the Paste. Here's an example where I Selected cells in Row2, Columns A, C, E and G and Copied. Then I Pasted into cell A4 and Pasted without selecting any other cells. As you can see, columns B, D F and H were unaffected, unlike when you would do that in Numbers '13.

Jerry

What you want to do can be done in Numbers 3 but it requires a change in your procedure.

1. Enter new data in cells D8, F8, H8. No change from what you are already doing.
2. Select C6, E6, I6 then Command C (copy). No change from what you are already doing.
3. Select C8, E8, I8 then Command V (paste). In Numbers 2 you can select C8 only then paste. Now you also need to select E8, I8, etc. before you paste.

I can't say that the new way is a bug or is just the way it works now. Excel does it a different way altogether. If in step 3 I select only cell C8 then Paste, it will paste into C8, D8, E8, etc. (consecutive cells). If I select C8, E8, I8 and try to paste it tells me I cannot do it.