How to copy column width in Excel worksheet

In this tutorial we will be seeing how to copy widths of column from one worksheet to another in Excel 2016, 2013 & 2010. This is a useful feature when you have customized the columns width in one worksheet and want to maintain the same column width for a different data set in another worksheet.

image

Select the columns then right click and pick Copy from the menu list. Now navigate to the new worksheet where you want to copy the column width then right click and select Paste Special from the displayed menu list.

image

In the Paste Special window, select the radio option with label as Column widths under Paste section. Then click OK button to copy the widths to the active worksheet.

image

In Category: Excel 2010, Office 2010

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 2 Comments
  • J Raglest November 8, 2013, 5:44 am

    I’ve been doing this for years. But now every time I try it I don’t get this “paste special” list, I get a selection of object types to copy into the target worksheet instead, with no mention of column widths. Have microsoft changed something or have I?

  • JWK June 6, 2014, 7:51 pm

    I have the same problem as J Raglest. What is the problem? –
    I’ve been doing this for years. But now every time I try it I don’t get this “paste special” list, I get a selection of object types to copy into the target worksheet instead, with no mention of column widths. Have microsoft changed something or have I?

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.