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

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

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.

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