Paste Special between Excel instances

If you have two instances of Excel open, you can’t Copy | Paste Special between the two. Which can be a bit of a pain.

Instead, create a new spreadsheet in the destination instance, paste into that, and then Copy | Paste Special from that one to the destination. Not elegant, but it does the job in most cases.

This entry was posted in Quick tips and tagged . Bookmark the permalink.