See all How-To Articles

How to Copy Cavalcade Widths in Excel & Google Sheets

In this article, you lot will learn how to copy column widths in Excel and Google Sheets.

copy column widths new5

Copy Column Widths

In Excel, when yous utilise the basic copy & paste option across the sheets, cavalcade widths are non pasted as well, and then you need to adjust cavalcade widths to fit the content manually. In order to skip that, you lot can use Paste Special selection to re-create column widths.

1. Get-go, select a data range in the first sheet (Sheet1) that you want to copy (in this example, A1:C5), right-click it, and choose Copy (or use the CTRL + C shortcut).

copy column widths new1

2. Later on that, select a cell in the second sheet (Sheet2) where you want to paste the data, right-click it and from the driblet-downward menu, click on Paste Special.

copy column widths new2

three. The Paste Special window will appear. In it, nether the Paste section, cull Column widths, and after that click on the OK button.

copy column widths 5

Note: A faster manner to practise this is to (1) select the jail cell where yous want to paste the data range, then (2) click on the arrow next to Paste Special. Nether the Paste section (three) click on the icon for column widths (Proceed Source Cavalcade Widths).

copy column widths 4 new

Equally a upshot of the steps above, the pasted information range is copied with the original column widths.

copy column widths new5

Compare the issue above to what happens when you apply the bones copy (CTRL + C) and paste (CTRL + V) option. As you can run across below, the cavalcade widths are not copied.

copy column widths new3

You can likewise use VBA code to paste column widths and other Paste Special options, including values, formats, transpose, skip blanks, and comments.

Copy Column Widths in Google Sheets

ane. To copy column widths in Google Sheets, select a information range in the commencement sheet (Sheet1) that you want to copy, right-click it, and choose Copy (or use CTRL + C shortcut).

copy column widths new7

ii. Later on that, select the place in the second sheet (Sheet2) where yous desire to paste it, and right-click it. From the drop-down carte, click on Paste special and then choose Paste cavalcade widths only.

copy column widths new8

3. As a result, the columns widths are pasted without any of the cell contents, as pictured below.

copy column widths new14

4. To fill the pasted columns with the values, right-click on the cells and from the drop-down menu, choose Paste (or you could utilise CTRL + V shortcut to paste it).

copy column widths new15

As a event of the steps in a higher place, the data range is copied with the original cavalcade widths.

copy column widths new13