Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

copy column widths - Excel

Status
Not open for further replies.

drain

Civil/Environmental
Joined
Mar 10, 2003
Messages
49
Location
US
Is there any way to copy the column widths when doing a copy in Excel?
 
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.
 
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
 
thanks guys
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top