Copy a worksheet

  • Thread starter Thread starter Poinsettia
  • Start date Start date
P

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.
 
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.
Click to expand...
 
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot copy worksheet to another file 2
Stop linked cells from changing when insert new row? 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy-Paste Chart into Word from Excel 2007 3
Paste Link Question 5
Excel 2007 crashes on copying worksheet to new workbook 0
Copy Worksheet 1
Formatting problem copying sheet 3

Back
Top