| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a worksheet
How do you copy an excel worksheet (ie used as a master copy) to a new
workbook without any changes in format occurring? Tried all the options under "Paste - special", but the page setup does not stay the same. -- Poinsettia |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy a worksheet
How are you doing the copying?
What changes? Poinsettia wrote: How do you copy an excel worksheet (ie used as a master copy) to a new workbook without any changes in format occurring? Tried all the options under "Paste - special", but the page setup does not stay the same. -- Poinsettia -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy a worksheet
Have you tried right-click on sheet tab and "Move or Copy"?
The entire sheet and all its attributes will be copied. Gord Dibben MS Excel MVP On Mon, 23 Mar 2009 16:04:02 -0700, Poinsettia wrote: How do you copy an excel worksheet (ie used as a master copy) to a new workbook without any changes in format occurring? Tried all the options under "Paste - special", but the page setup does not stay the same. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy a worksheet
Not sure this is what you are after....but I just do a "Save As" and save the
whole worksheet to a new excel worksheet with a different name. All formattiing and even protections are saved. -- thanks, Wurkingurl "Poinsettia" wrote: How do you copy an excel worksheet (ie used as a master copy) to a new workbook without any changes in format occurring? Tried all the options under "Paste - special", but the page setup does not stay the same. -- Poinsettia |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Worksheet wont copy objects. | Excel Worksheet Functions | |||
| copy graph from a Worksheet based on a field in another Worksheet | Excel Worksheet Functions | |||
| Move/Copy or Copy/Insert worksheet? | Excel Discussion (Misc queries) | |||
| copy part of a worksheet into a worksheet in the same file/keepi. | Excel Worksheet Functions | |||
| Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
Linear Mode
