Trouble with formulae? Lookups not going so well? The Wizard of Excel can help. Dan Harrison offers practical tips and examples, as well as Excel training and consulting.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.
