| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying All Cells in XL 2007
I am trying to copy an enitre worksheet to another worksheet in a new
workbook. In XL 2003 and prior all you had to do was highligh all the cells by clicking top left corner then copy and go to the new workbook, select all the celss via the same mtehod and paste. This would copy everything, including the formats of the cells. In XL 2007 it copies everything, except the formatting. How do I copy it so the formatting comes across as well? BVass |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying All Cells in XL 2007
Why copy/paste at all?
Hold SHIFT; drag the worksheet tab to left or tight; if it was Sheet 1 you get Sheet1 (2) which is an exact copy of the original best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "BVass" wrote in message ... I am trying to copy an enitre worksheet to another worksheet in a new workbook. In XL 2003 and prior all you had to do was highligh all the cells by clicking top left corner then copy and go to the new workbook, select all the celss via the same mtehod and paste. This would copy everything, including the formats of the cells. In XL 2007 it copies everything, except the formatting. How do I copy it so the formatting comes across as well? BVass |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying All Cells in XL 2007
Bernard,
If you read correctly I wish to copy the worksheet to a new workbook. Doing what you are suggesting copies it to the same workbook....so this is no hlep. BVass "Bernard Liengme" wrote: Why copy/paste at all? Hold SHIFT; drag the worksheet tab to left or tight; if it was Sheet 1 you get Sheet1 (2) which is an exact copy of the original best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "BVass" wrote in message ... I am trying to copy an enitre worksheet to another worksheet in a new workbook. In XL 2003 and prior all you had to do was highligh all the cells by clicking top left corner then copy and go to the new workbook, select all the celss via the same mtehod and paste. This would copy everything, including the formats of the cells. In XL 2007 it copies everything, except the formatting. How do I copy it so the formatting comes across as well? BVass |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying All Cells in XL 2007
Then r-click the tab and select Move or Copy to new book!
BVass wrote: Bernard, If you read correctly I wish to copy the worksheet to a new workbook. Doing what you are suggesting copies it to the same workbook....so this is no hlep. BVass "Bernard Liengme" wrote: Why copy/paste at all? Hold SHIFT; drag the worksheet tab to left or tight; if it was Sheet 1 you get Sheet1 (2) which is an exact copy of the original best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "BVass" wrote in message ... I am trying to copy an enitre worksheet to another worksheet in a new workbook. In XL 2003 and prior all you had to do was highligh all the cells by clicking top left corner then copy and go to the new workbook, select all the celss via the same mtehod and paste. This would copy everything, including the formats of the cells. In XL 2007 it copies everything, except the formatting. How do I copy it so the formatting comes across as well? BVass |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying All Cells in XL 2007
Just use Windows Arrange and follow my directions
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "BVass" wrote in message ... Bernard, If you read correctly I wish to copy the worksheet to a new workbook. Doing what you are suggesting copies it to the same workbook....so this is no hlep. BVass "Bernard Liengme" wrote: Why copy/paste at all? Hold SHIFT; drag the worksheet tab to left or tight; if it was Sheet 1 you get Sheet1 (2) which is an exact copy of the original best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "BVass" wrote in message ... I am trying to copy an enitre worksheet to another worksheet in a new workbook. In XL 2003 and prior all you had to do was highligh all the cells by clicking top left corner then copy and go to the new workbook, select all the celss via the same mtehod and paste. This would copy everything, including the formats of the cells. In XL 2007 it copies everything, except the formatting. How do I copy it so the formatting comes across as well? BVass |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Conditional Formatting, copying | Excel Discussion (Misc queries) | |||
| copying charts in excel 2007 | Excel Discussion (Misc queries) | |||
| copying charts in excel 2007 | Charts and Charting in Excel | |||
| Excel 2007 - Filtering and copying | Excel Discussion (Misc queries) | |||
| Copying data - Excel 2007 | Excel Worksheet Functions | |||
Linear Mode
