View Single Post
 
Old 01-24-2019, 05:31 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

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.
Reply With Quote