When selecting and copying a range in one spread sheet and pasting in into
another new sheet, is there a way to maintain all original formatting
including column widths? I try to copy and paste and end up having to
readjust the column width in every column in order to see everything. Thank
you very much for any help here
Jerry

After selecting the destination cell(s)

Instead of pressing [Enter] to paste...
From the Excel main menu
<edit><paste>
(that will paste All to the destination)

Then...
<edit><paste special>....Check: Column Widths.....Press [Enter]

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"JERRY" wrote:

> When selecting and copying a range in one spread sheet and pasting in into
> another new sheet, is there a way to maintain all original formatting
> including column widths? I try to copy and paste and end up having to
> readjust the column width in every column in order to see everything. Thank
> you very much for any help here
> Jerry
>
>
>

Yes... Thanks Ron
Appreciated

"Ron Coderre" <(E-Mail Removed)> wrote in message
news:B52C6DC4-01BC-459C-827B-(E-Mail Removed)...
> After selecting the destination cell(s)
>
> Instead of pressing [Enter] to paste...
> From the Excel main menu
> <edit><paste>
> (that will paste All to the destination)
>
> Then...
> <edit><paste special>....Check: Column Widths.....Press [Enter]
>
> Is that something you can work with?
> ***********
> Regards,
> Ron
>
> XL2002, WinXP
>
>
> "JERRY" wrote:
>
>> When selecting and copying a range in one spread sheet and pasting in
>> into
>> another new sheet, is there a way to maintain all original formatting
>> including column widths? I try to copy and paste and end up having to
>> readjust the column width in every column in order to see everything.
>> Thank
>> you very much for any help here
>> Jerry
>>
>>
>>