exact copy

  • Thread starter Thread starter Jean-Paul
  • Start date Start date
J

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
 
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
 
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
 
sorry

do not use paste specail values but use option : all

then u will find the option keep source column width
 
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
 
Back
Top