To copy column width to another sheet in Excel or the same sheet, you need to use the Keep Source Column Widths option. First, copy the column you want to duplicate from the source file.

How to Copy Format Changes From One Table to Another in an Excel Spreadsheet. Microsoft Excel lets you format tables, adding borders and colors, and lets you format the text in them, editing font ...