Copy a worksheet

[Poinsettia]

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.

 

[Dave Peterson]

How are you doing the copying?

What changes?

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.

 

[Gord Dibben]

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

 

[wrkingurl]

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.