Excel, Cut & Paste

[kevmeister123]

Hi all, I have a quick question which you might be able to help me on.

My boss says he used to "cut" some cells from excel file 1, and then paste them into excel file 2. After pasting the cells into file 2, the cells in file 1 would disappear because they were "cut".

When i try to reproduce this, after pasting the contents into file 2, the cell contents remain in file 1 as well with the marching ants still round the cells.

When I cut the cells from file 1 sheet 1, and paste them into sheet 2 of the same file, the cells "do" disappear from sheet 1 because they were "cut".

Is there an option that says "when cutting & pasting data leave original data intact?"

thanks for your insights.

Kev

 

[TonyJollans]

The way Excel cuts is correct within a single instance of Excel, but when you paste into another application (including a separate instance of Excel) it is incorrect and always has been, AFAIK. Could it be that you have two workbooks open in two instances of Excel?

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[kevmeister123]

Thanks Tony that's it exactly, i opened two separate instances of excel and it didn't clear the original data, but then opened 2 workbooks in the same instance and it did clear the original cell.

thank you very much you've answered my query.

cheers

kev

 

[GSCaupling]

Is there an option that says "when cutting & pasting data leave original data intact?"

Try COPY instead of CUT to leave the original intact.

GS

[small][navy]*****************^*****************[/navy][/small]
[red]I think of the word processor as the pen's e-quill.[/red]