exact copy

[Jean-Paul]

Hi,

When I select an entire region in sheet 1 and copy it to sheet 2 with
copy paste special everything, everything is copied except the layout
(rowheight, columnwigth...)
How to get an exact copy?
Thanks
JP

 

[muddan madhu]

copy | paste special | values | ok

once u paste the value u will find the auto fill option (below
destination cell) use check for the option and select keep source
column width

 

[Jean-Paul]

sorry... don't understand it..
I select a region form A1 to K25
select Copy
Go to next sheet
position the cursor at A1
choose: PAste Special
when I choose (like you say) values and OK everything is copied into the
new sheet without any layout
On the lower right corner I have "paste-options"
I don't see any option "keep source column width"

What do I do wrong?
Thanks

 

[muddan madhu]

sorry

do not use paste specail values but use option : all

then u will find the option keep source column width

 

[Jean-Paul]

I don't see any option "keep source column width"
(BTW I also need the column height, bold or not... evrything)
I want an EXACT copy.

Hope you can help

 

[Roger Govier]

Hi

Try
Copy>Paste Special>Formats followed by Copy>Paste Special>all