| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
exact copy
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
exact copy
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 On Oct 16, 1:04*pm, Jean-Paul wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
exact copy
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 wrote: 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 On Oct 16, 1:04 pm, Jean-Paul wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
exact copy
sorry
do not use paste specail values but use option : all then u will find the option keep source column width On Oct 16, 2:05*pm, Jean-Paul wrote: 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 wrote: 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 On Oct 16, 1:04 pm, Jean-Paul wrote: 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- Hide quoted text - - Show quoted text - |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
exact copy
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 muddan madhu wrote: sorry do not use paste specail values but use option : all then u will find the option keep source column width On Oct 16, 2:05 pm, Jean-Paul wrote: 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 wrote: 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 On Oct 16, 1:04 pm, Jean-Paul wrote: 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- Hide quoted text - - Show quoted text - |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
exact copy
Hi
Try CopyPaste SpecialFormats followed by CopyPaste Specialall -- Regards Roger Govier "Jean-Paul" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and Replicate exact formulas | Excel Worksheet Functions | |||
| Exact Copy | Excel Discussion (Misc queries) | |||
| How to I past the exact copy of a form without it shrinking | Excel Worksheet Functions | |||
| Exact formula copy. | Excel Discussion (Misc queries) | |||
| How to do the exact copy of a formula | Excel Worksheet Functions | |||
Linear Mode
