Share this content
6

Copy vs Cut in Excel

Copy vs Cut in Excel

Didn't find your answer?

I've been copying data in Excel from one worksheet and pasting it into another

I've just noticed that if I use Copy, then the row height is brought over as well. If I use Cut, it isn't.

Not many people know this.
David Carter

Replies (6)

Please login or register to join the discussion.

avatar
By neileg
18th Jul 2006 14:40

I agree with Clint
I'm using XL2000

Thanks (0)
avatar
By David Carter
21st Jul 2006 14:03

It's a mystery
I think this one will have to remain unsolved

Thanks (0)
avatar
By Richard Willis
19th Jul 2006 10:27

Try 'Paste Special/All'
David

If you use 'Paste Special/All' it should carry all formatting along with the source. If the source has formulae which you do not wish to read from the source workbook, you can use 'Paste Special/Values' and 'Paste Special/Formats' one after the other to carry only the values & formats across.

I'm not totally sure, but I think that Excel will allow an incoming paste to update formats if the original target sheet has no specifically defined formats. However if it has I think that they take precedence.

Thanks (0)
avatar
By AnonymousUser
18th Jul 2006 13:29

On my system ...
... both copy and cut behave the same (in this regard).

If you select the entire row, then the row height is preserved whether you copy or cut.

If you select cells that fall short of the entire row, then the row height is not preserved, but again whether you copy or cut.

I am using XL2002. Would be surprised if it differs in 2003.

Thanks (0)
avatar
By David Carter
18th Jul 2006 23:08

No, I've checked
You have me worried, so I've checked again. (This is Excel 2003.)

Worksheet A is default font Arial 8, row height 11.25. Contains 100 rows of data.

Worksheet B is default Arial 10, row height 12.75. Contains no data.

I'm copying 10 rows from A to B, highlighting entire line by clicking on tile to left of column A.

If I select Copy, then Paste or Insert Cut Cells into B, the height of the Pasted rows is now 11.25.

If I select Cut, then Paste or Insert Cut Cells into B, the height of the pasted rows in B is now 15.00. I have no idea why it is increasing from 12.75 to 15.00

Seems to be peculiar to Excel 2003

Thanks (0)
avatar
By AnonymousUser
19th Jul 2006 09:00

Musht be shomething else
I have now tried it on XL2003 machine with precisely your parameters, and on my machine it still shows copy and cut behaving the same - in both cases the row height is pasted with the data.

Thanks (0)
Share this content