Paste Special Column Widths
By Wyn Hopkins
If you copy some nicely formatted data from one sheet to another, one of the annoying and time consuming issues is then having to re-size the column widths.
As you can see pasting the table above into a new sheet, means that I then need to narrow some columns and widen others in order to get my data to look like the original.
However, a simple few clicks can save you a lot of time. Here’s what you need to do:
Step 1: Do your copy and paste as you would normally
Step 2: RIGHT-CLICK in the area where you just pasted, select Paste Special followed by COLUMN WIDTHS
Step 3: Click OK and hey presto! All columns now match your original formatting.