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?

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?

Thank you for your kind and prompt response - following your process
highlighting the initial spreadsheet area and moving to the 2nd -- all I get
with CTRL-V is a one low tone beep - no data - Perhaps disrelated but making
reference in a formular to data in another worksheet just does not work
either. In prior excel's it was as easy as in the formula expression to point
to the external reference and click, in 2007 it acts like here the two
spreadsheets cannot interact.

"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?

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?

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?

Thanks again

I do have two sessions open, many times 6-8 open workbooks moving data
between them (this I do at recommendation of MS due to the limitation on
allocating resources in excel 2007 - as I was getting messages such as 'not
enough resources ..." ) but in "this copy process" the two worksheets are in
the "same" session and opened via the process you suggested here. The
original was converted from excel 2003 then I attempted to copy. Assuming
the conversion was the problem, I created a test excel 2007 worksheet and
attempted to bring over the data - I was successful in getting data, number
font, and color to copy but there appears no "paste special" facility to
bring over column width etc as in 2003. If I may ask this last question (as
one who has been around since Visicalc, Lotus, Sympnony, QuatroPro and
everyversion of MS Office) ... is "paste special" between worksheets gone and
when will we ever get this (one of the most useful functions) back?

Again - thank you - this is a great resouces muchly appreciated

"Sheeloo" wrote:

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?

Paste Special is very much there...

In the same session, you should get all the workbooks in that session in the
Move/Copy sheet dropdown...

If you are pasting across sessions then limitations of Clipboard come into
play...

I am surprised that you don't see Paste Special...

Try this within the sheet
Copy a set of cellls

Right-click on any cell... you should see Paste Special as an option..

In fact this should work across sessions also...

Other than finding the options in the new RIBBON, I have found Excel 2007 to
be better than 2003 .

"CGCPA" wrote:

Thanks again

I do have two sessions open, many times 6-8 open workbooks moving data
between them (this I do at recommendation of MS due to the limitation on
allocating resources in excel 2007 - as I was getting messages such as 'not
enough resources ..." ) but in "this copy process" the two worksheets are in
the "same" session and opened via the process you suggested here. The
original was converted from excel 2003 then I attempted to copy. Assuming
the conversion was the problem, I created a test excel 2007 worksheet and
attempted to bring over the data - I was successful in getting data, number
font, and color to copy but there appears no "paste special" facility to
bring over column width etc as in 2003. If I may ask this last question (as
one who has been around since Visicalc, Lotus, Sympnony, QuatroPro and
everyversion of MS Office) ... is "paste special" between worksheets gone and
when will we ever get this (one of the most useful functions) back?

Again - thank you - this is a great resouces muchly appreciated

"Sheeloo" wrote:

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?