Excel 2007 Copy to new worksheet

1

136006

In Excel 2007, I can easily cut or copy then paste any cell or field of cells
within the same document (any tab in the document) or any other type of
document (Word, email, etc). However, the moment I select a different Excel
document, I am unable to paste to the new document. I noticed that I can
make it work only if I have the Clipboard open, then I can only use the
"Paste All" button on the Clipboard (control-V and right-clicking do not
work). Is there a setting I need to adjust to make this easier?
 
G

Gord Dibben

Sounds like you have two instances of Excel running with a workbook in each.

These two instances will not recognize each other.

Close one instance and open both workbooks in one instance.


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

Similar Threads

Cannot copy worksheet to another file 2
COPY EXCEL 2007 9
copy doument names from a file into excel 6
Copy worksheet to new doc w/formulas not referencing previous doc 4
How to make Ctrl-C, ctrl-V work in Office 2007 1
"Cannot Empty the Clipboard" in Excel 2007 1
Excel found unreadable contenet in file "...". in excel 2007 1
how to copy, do something else, THEN paste? 1

Top