It’s not easy to fool Excel, but with a few extra clicks, you can work around this odd pasting behavior. If you paste formatted values into a cell with another applied format, the pasted format wins.

Susan Harkins shows you a quick method for removing validation rules for multiple ranges in Excel, at the same time. Validation is a powerful feature that lets you control the data users can enter ...