Cut and insert

[PPatrick]

I have used cut and paste before and it is pretty straightforward. Is it possible to do a cut and insert? Or do you have to have the cells/lines already available and do a cut and paste?
Thanks in advance!

[alansidman]

What do you mean by cut and insert. Can you provide an example of what you wish to accomplish.

[PPatrick]

I would like to move come rows of data into a different location on the spreadsheet. (actually my boss wants to do this).

I have always inserted the rows where I needed them, then gone to the data and cut then pasted into those rows. My boss wants to just highlight the data, cut the data, and then go to the desired location and insert them there.

[alansidman]

Without using VBA, what you wish to happen when you do it will overwrite the existing cells.

[PPatrick]

What is VBA?

I didn't think it would insert but just over write.

[PPatrick]

Okay, so this is possible - just highlight cells,right click, click on cut, go to desired placement, click insert cut cells and it is done. Have done this several times no issues on some spreadsheets it works fine. What would prevent this from happening? The worksheet is not protected

[alansidman]

When I cut a range of cells and try to paste them in another location, they overwrite the existing cells. If you wish to insert new rows and not do it manually then you will need to use Visual Basic Application (VBA) which is a sub program that allows you to automate some of the steps you do manually.

[Aardigspook]

@PPatrick: You've answered your own question from post 1 in post 6 - use 'insert cut cells' instead of 'paste' - but you seem to have a follow-up question - is your solution not working on one particular file?

[alansidman]

@Aardigspook
Thanks for pointing out the cut and insert/paste function. I was not aware of this capability. Was able to test with right click.

Alan