Copy Column Widths along with Data in Excel

Dennis Faas's picture

Most folks know the agony of having to resize column widths in Microsoft Excel when you move data from one formatted spreadsheet to another. Thankfully, Microsoft Office 2002 and 2003 offers you some relief from this painstaking chore!

Prior to Microsoft Excel 2002, you had to use the Paste Special menu to retain the column width settings of the source file. However, if you use the 'Smart Tags' function in Excel 2002 and 2003, your column widths will be reformatted in just a couple of mouse clicks!

Simply follow these steps in Excel 2002 or Excel 2003:

  1. Copy the data that you want transferred to the new worksheet.
  2. Click on the cell in the new worksheet where you want to place the data, and then click the Paste button.
  3. Click the Paste Option Smart Tag button and select Keep Source Column Widths.

Excel will automatically adjust the column widths to match the width of the columns of the source worksheet.

Now wasn't that easy?

Visit Carol's web site to learn more tips like this one!

Rate this article: 
No votes yet