A 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.

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

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)

Then click the “Keep Source Column Widths”

Here you go!

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”

Easy! 🙂