Dear all,
Thanks for Malllycat. But the method only copy heights ans
width. Can I copy heights and width and data too? Thanks.
Mallycat 寫道：

hon123456 Wrote:
Is there
any mothod to let the pasted cell have the same width and height as
the
original cells without adjusting the width manully?


There is a Paste\Special\Column width option to fix the widths. The
height is a separate step. Highlight the FROM row (entire row) then
Copy, Paste Special\Formats (NB, you don't have to use formats to copy
the row heights, but if you don't, you will get the data too.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=555177