Paste Special Column Widths

Home/Formatting/ Paste Special Column Widths

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.

Paste Special Column Widths - Table A

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.

Paste Special Column Widths - Table B

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

Paste Special Column Widths - Table C

Step 3: Click OK and hey presto! All columns now match your original formatting.

 

2017-03-08T03:54:05+00:00 Formatting|