Copy column widths along with the data in Excel

Any IT pros who have worked with Microsoft Excel are familiar with the time-consuming chore of reformatting column widths when you move data from one spreadsheet to another. Find out how Office 2002 and 2003's Smart Tags can significantly lighten your reformatting load.

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

Before Microsoft Word 2002, you had to use the Paste Special menu to retain the column width settings of the source file. With Word 2002 and 2003's Smart Tags, you can have Excel reformat the column widths for you with just a couple of mouse clicks.

Follow these steps in Excel 2002 or Excel 2003:

  1. Copy the data you want to paste to a 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.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox