Copy and Paste table while keeping column widths

Excel Tips - Paste with Columns Width 0A simple trick (click) can save you lots of time.

Below is a commonly seen scenario in my work life:

A user wanted to copy a table to a new worksheet/workbook, what he/she normally did was CRTL C then CTRL V.

Excel Tips - Paste with Columns Width 1

The pasted result was however not desirable because of the column widths.

Excel Tips - Paste with Columns Width 2

Then he/she would adjust the column widths one by one again…

Did you know… you can do that in just two clicks?

Right after the pasting, click on the smart tag (see below) on the lower right of the range. (note: the smart tag disappears if you perform other action after the paste)Excel Tips - Paste with Columns Width 5

Then click the “Keep Source Column Widths

Excel Tips - Paste with Columns Width 3

Here you go!

Excel Tips - Paste with Columns Width 4

An alterative way is to right click the destination cell, hover on Paste –> you will then see the same paste menu below.  What you need to do is to select “Keep Source Column Widths

Excel Tips - Paste with Columns Width 3

Easy! 🙂

Advertisements
This entry was posted in Excel Tips and tagged , . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s