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?
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”