copy column widths - Excel

[drain]

Is there any way to copy the column widths when doing a copy in Excel?

 

[dsi]

You have to do a separate Paste operation:
Paste Special > Formats

DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.

 

[jproj]

drain:

Follow dsi's directions, but instead of selecting "Formats", select "Column widths". It may not be an option in versions earlier than excel 2000... If your version doesn't have "Column widths" as an option, "Formats" will work too.

jproj

 

[drain]

thanks guys