When you don't need formulas anymore on old location, then copy, and then Paste Values into same range.
When you want to keep formulas in old sheet, then right-click on sheet tab, Select Move or Copy, check Create a copy checkbox, and click OK. After that, copy all data in new worksheet, and use Past Special to write the datarange over with values.
Not much faster, but you don't have to format the sheet, and to set column widths.
|