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.
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.
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.