Copy/Paste Special in Excel

A

April H

I have 2 separate excel files running on two separate computer monitors. I
am trying to copy and “paste special†a block of cells to move the value but
not the formatting from one document to the other. It will not allow me to
do this unless I want to paste an object into the target file. The only
other way I can paste the cells is a simple paste (by highlighting the cells
and pasting into the new location) in which the formatting is carried from
the origination document.
 
G

Gord Dibben

April

This is the behaviour when copying between workbooks in two instances of Excel.

I know of no way around it if you need two instances of Excel running.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top