Using MS Excel’s Paste Special options can make use of your creative talents.
It is often possible to save a lot of work by combining several operations in consecutive Paste Special actions. For instance, select All Except Borders to copy formulas and cell formatting without adding underlines and table borders from the original data.
Then repeat the Paste Special option and select the Column Widths option.
This will duplicate an entire table on a new worksheet, leaving out only the borders and underlines!