Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Yes I get "paste special" in a single workbook ... I would have hoed that
after months of labor with 2007 I would share your 2007 opinion regretfully nowever the many difficulities experienced in (office) excel 2007 as this does not allow me to move our staff and standarize our firm on 2007. We will continue to support out clients in its use but 2003 is for us a much more refined and efficient program. Best regards . bye "Sheeloo" wrote: 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? |
#9
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() "CGCPA" wrote: Yes I get "paste special" in a single workbook ... I would have hoed that after months of labor with 2007 I would share your 2007 opinion regretfully nowever the many difficulities experienced in (office) excel 2007 as this does not allow me to move our staff and standarize our firm on 2007. We will continue to support out clients in its use but 2003 is for us a much more refined and efficient program. Best regards . bye "Sheeloo" wrote: 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? |
#10
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() "Stan" wrote: When I try to copy a section of a spreadsheet to another spreadsheet it changes the year from 08 to 12, it gets all of the other columns right, including phone numbers. There are no formulas involved, I have formatted the cells on both sheets for dates, the only thing that seems to work is to add / after the date. I have the same problem on two machines since switching to 07, one is Vista and the other is a Mac. Stan "CGCPA" wrote: Yes I get "paste special" in a single workbook ... I would have hoed that after months of labor with 2007 I would share your 2007 opinion regretfully nowever the many difficulities experienced in (office) excel 2007 as this does not allow me to move our staff and standarize our firm on 2007. We will continue to support out clients in its use but 2003 is for us a much more refined and efficient program. Best regards . bye "Sheeloo" wrote: 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? |
#11
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
1904 date format is standard on the Mac and 1900 format is standard on
Windows. You'll need to change the options on one of them. If you've got data which needs translating between the 2 and you don't want to change the options, add or subtract 1462. -- David Biddulph "Stan" wrote in message ... "Stan" wrote: When I try to copy a section of a spreadsheet to another spreadsheet it changes the year from 08 to 12, it gets all of the other columns right, including phone numbers. There are no formulas involved, I have formatted the cells on both sheets for dates, the only thing that seems to work is to add / after the date. I have the same problem on two machines since switching to 07, one is Vista and the other is a Mac. Stan "CGCPA" wrote: Yes I get "paste special" in a single workbook ... I would have hoed that after months of labor with 2007 I would share your 2007 opinion regretfully nowever the many difficulities experienced in (office) excel 2007 as this does not allow me to move our staff and standarize our firm on 2007. We will continue to support out clients in its use but 2003 is for us a much more refined and efficient program. Best regards . bye "Sheeloo" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel 2007 copy row heights | Excel Discussion (Misc queries) | |||
Chart Selection - Excel 2007 copy to Powerpoint 2007 | Charts and Charting in Excel | |||
Excel 2007 cannot copy using mouse | Excel Discussion (Misc queries) | |||
Copy color - Excel 2007 | Excel Discussion (Misc queries) | |||
Copy color - Excel 2007 | Excel Discussion (Misc queries) |