Copy Excel Column Widths Along With Column Data

When you copy data between two different spreadsheets, the column widths are not copied. Unless you use the Paste Special command, this can become a real chore when you invest your time in resizing column widths for your data only to have to do it all over when the data is copied into another spreadsheet.

If you are using Excel 2002 or Excel 2003, there is another way that you can avoid having to resize your columns. By using Smart Tags, you can have Excel format the columns as they appear in your source file.

Within the source spreadsheet, copy the data you want pasted. In the new worksheet, select the cell where you want to data placed and click Paste. Click the Paste Option Smart Tag button and select Keep Source Column Widths. Excel will automatically change the column widths to match those in the source worksheet.

[tags]excel,spreadsheet,resize column,smart tag,format[/tags]