Locate and select Paste Values from the options. This is definitely a great method to copy cell format and paste to the desired selection. Clear Formatting In Excel How To Remove All Formats In A