What method did you use to create the copy worksheet? I find the most effective way is to right click on the tab of the worksheet I want to copy then select the <Move or Copy> option. All existing formatting, including column widths, is replicated as well as data and formulas.