One possible reason is that you are opening two instances of Excel.

Try this
Open Excel
Open first workbook from Office Button|Open option
Open the second one the same way

Now if you right-click and Move/Copy you should see both workbooks...


"CGCPA" wrote:

Did it again - this time I did get a copy but no formatting of column
width's, fonts style i.e. format of number, color highlighting.

What I'm looking for is the paste options to "paste special" all the
formating of the original ...

Greatly appreciated -- thanks

"Sheeloo" wrote:

Select the cells you want to copy
Go to the other sheet and go to where you want to paste (top-left corner of
the area you want it to be)
Press CTRL-V
You should get everything ...

To test open two new workbooks
Do some formatting on the first, copy and paste it to the other...

Let us know if you still have problems..

"CGCPA" wrote:

I attempt to copy a worksheet from one excel file to another, I have both
open, highlight the area in worksheet #1, hit copy, it appears on the
clipboard, I go to worksheet #2, put cursor on specific cell (the top left
whare I want the data) go to clipboard, place cursor on data entray, and the
option includes only Paste or delete. When I copy the data, no attributes
such as formatting, font, highlight etc transfers over. The paste function
does not provide "paste special" as an option. Copy / paste of complex data
is critical to my work, How does this work in excel 2007? Excel 2003 was
terrific what happened here?