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.