Copy and past ... and maintain all formats including column widths

  • Thread starter Thread starter JERRY
  • Start date Start date
J

JERRY

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
 
Yes... Thanks Ron
Appreciated

Ron Coderre said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top