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.
- First, copy the data using any method you like, probably [Ctrl]+C and [Ctrl]+V.
- After pasting the data, right-click the new range.
- Choose Paste Special from the resulting context menu.
- In the Paste section, click the Column Widths option. Word 2003 users must then click OK.