Office Q&A: How to stop Excel’s paste task from overwriting destination cell’s format Your email has been sent It's not easy to fool Excel, but with a few extra clicks, you can work around ...

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.

To take a snapshot of a range not formatted as an Excel table using the Linked Picture tool, select the data, press Ctrl+C to copy it, and click "Linked Picture" in the Paste drop-down menu.