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.

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

Cutting and pasting ranges of cells is a common operation in Excel, and Microsoft's Visual Basic offers streamlined functionality to easily automate the process.

How to Copy From the Internet and Paste Into Excel. Microsoft Excel accepts data input from your keyboard, through file import and by pasting the contents of your computer clipboard into a worksheet.