Make sure that you are copying between 2 documents opened within one
instance of Excel, rather than opening 2 instances of Excel.
--
David Biddulph

geb wrote:
When I want to copy data with paste special I used to have the option
to copy all and it would copy the entire format. Now however it is a
different pop-up window that gives me the options to paste it as an
object, picture, bitmap etc.

Does anyone know why this changed and how I can go back to copying the
entire format incl. borders etc? Thank you in advance.