cut and paste without over-writing

Question

Level 1

77 points

cut and paste without over-writing

i've asked this a number of times as I drop in and out of using numbers during my move to mac and basically want to apologize for asking this again. however -

i am cutting (CTRL + X) sets of rows by simply multiple selecting the rows and running the cut command line option. i /then/ want to paste this into the same numbers spreadsheet without having to create a ton of empty rows and then deleting the ones that were not used and the way I am /trying/ to do this is by selecting an empty row clicking in the first column (just once) and then running CTRL + V.

however, this is "eating up" data that is below this row and i want the pasted data to insert itself so that it /creates/ rows and doesn/t cannibalize the rows below which have mission critical data in them.

can anyone clear up what I am not doing or doing wrong here? is there a setting that will stop this behaviour which seems very dangerous to me if not caught?

TIA.

Posted on Dec 25, 2011 10:06 AM

Reply

Answer 1

Best reply

KOENIG Yvan

Level 8

41,807 points

Dec 25, 2011 12:47 PM in response to hotwheels22

Question asked and answered several times.

Asking several time the same question will not change the application's behavior.

Not only it was answered several times but it's explained in Numbers User Guide.

You are not using XL so there is no reason to guess that the app will behase like the other.

If you don't want to replace existing values, you must create the block of blank cells to paste in.

Yvan KOENIG (VALLAURIS, France) dimanche 25 décembre 2011 21:47:14

iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.2

My iDisk is : <http://public.me.com/koenigyvan>

Please :

Search for questions similar to your own

before submitting them to the community

Reply

Answer 2

hotwheels22 Author

Level 1

77 points

Dec 25, 2011 3:47 PM in response to KOENIG Yvan

Hi Yvan.

Thanks. I guess I keep coming back to this because I can't imagine that I am doing it right.

You mean I copy a set of rows (say 10 of them) and that I then I have to manually create 9 rows under the empty row that I want then inserted under - or I will overwrite the text in the rows below?

Thanks!

Reply

Answer 3

Dec 25, 2011 6:52 PM in response to hotwheels22

Jon,

You haven't said if your selection of rows in the source table is contiguous. I'll assume that it is.

Method 1.

After cutting the rows that you wish to move, Paste them to a blank area of the canvas. Then select the new table and drag it into the receiving table. Watch as you move the cursor into the receiving table how the horizontal borders split as you hover over them. If you let go the mouse button, the past will occur at the split border without overwrite.

Method 2.

Select the rows to be moved. Drag them to the location where you want to split the table to receive them. Let go.

Regards,

Jerry

Reply

Answer 4

KOENIG Yvan

Level 8

41,807 points

Dec 26, 2011 2:55 AM in response to hotwheels22

It depends.

If the blank row is at the bottom of the table, the other ones will be created automatically.

If the blank row is between two filled rows (what I assumed given your question about 'overWriting') yes, you must create the new blank rows.

At least it's what I thought when I posted.

Since, I looked back in Numbers User Guide and found an info which I missed :

Yvan KOENIG (VALLAURIS, France) lundi 26 décembre 2011 11:54:59

iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.2

My iDisk is :

http://public.me.com/koenigyvan

Please : Search for questions similar to your own before submitting them to the community

For iWork's applications dedicated to iOS, go to :

https://discussions.apple.com/community/app_store/iwork_for_ios

Reply

Answer 5

hotwheels22 Author

Level 1

77 points

Dec 26, 2011 10:39 AM in response to KOENIG Yvan

God. Thank you Yvan.

The Insert > Copied Cells functionality is what I was really needing.

Seems odd that this could not be the default behavior or even a right mouse click but this gets me moving in a much more productive way.

Thank you.

Reply

Answer 6

hotwheels22 Author

Level 1

77 points

Dec 26, 2011 10:42 AM in response to Jerrold Green1

Thank you Jerrold.

I obviously have a lot to learn here and some of it I am finding not so easy.

That said, my methodology was to multiple select the row numbers on the left hand side, CTRL + X and then Yvan has showed me that I can pull down from Insert and do a "Copied Rows" which is really a great help for me.

My workaround on this was very inefficient so a big THANKS for the help.

Regards.

Reply