Paste Column Width along with Excel Data

When you paste data into an Excel worksheet, do you find yourself resizing each column width to match the original width?

Excel 2010 allows you to quickly paste the column width along with your data.  This formatting can also be accomplished in earlier versions of Excel; however, it requires some additional steps.

Excel 2010

1. Select the Excel data to be copied.
2. Press Ctrl+c (to copy the data)
3. Right-click in the cell where you want to paste the data.
4. Select "Paste Special" and then click "Keep source column widths" in the context menu.

Excel 2007 or 2010

1. Select the Excel data to be copied.
2. Press Ctrl+c (to copy the data)
3. Click in the cell where you want to paste the data.
4. Press Ctrl+v (to paste the data).
5. Click the Paste Options icon and click "Keep Source Column Widths".

Note: The Paste Options icon appears near the bottom right corner of the pasted data.
Excel 2003

1. Select the Excel data to be copied.
2. Press Ctrl+c (to copy the data)
3. Right-click in the cell where you want to paste the data.
4. Click "Paste Special".
5. Select "Column Widths" and then click "OK".
6. Press Ctrl+v (to paste the data).