Quickly copy a source column's width when copying data in Excel

Copying data from one Excel column to another often means an additional task; you must adjust the target column's width. Fortunately, there's an easy way to do so using Paste Special.

When you copy data from one column to another, you probably adjust the target column's width to accommodate the new values. If you do so by checking the source column's width and then setting the target column's width to match—STOP! You're working too hard! There's a quick and easy way to copy a source column's width to a target column.

To copy a source column's width to the target column, do the following:

  1. First, copy the data using any method you like, probably [Ctrl]+C and [Ctrl]+V.
  2. After pasting the data, right-click the new range.
  3. Choose Paste Special from the resulting context menu.
  4. In the Paste section, click the Column Widths option. Word 2003 users must then click OK.
Excel will automatically update the target column's column width to match the source columns in just three quick clicks!

About Susan Harkins

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

Editor's Picks

Free Newsletters, In your Inbox