Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

copy excel worksheet

Status
Not open for further replies.
kitnba

kitnba

MIS
Jul 31, 2000
132
HK
I want to copy a excel worksheet to the new one.

How can I do the copy worksheet include page setup and margin setup ?

I only can copy the formula and the value now. I don't want to setup this thing many times.

Thanks
 
Sort by date Sort by votes
You can right-click on the worksheet tab and copy there. I believe it make an exact copy.

 
Upvote 0 Downvote
Yes Kathryn is correct.

Edit>Move or Copy Sheet
or right click tab and select Move or Copy Sheet

As an aside, this will also allow you to copy a protected sheet in Excel 95 and the copy will not be protected. Don't know if it is the same in Excel 2k.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
291
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
287
combo
combo
ladyck3
  • Locked
  • Question
Excel 365 - Working with Tables - Calculating data from one worksheet to another. 2
2
Replies
30
Views
459
combo
combo
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
861
shytott
shytott
renigar
  • Question
Excel Power Query refresh error
Replies
3
Views
625
SoftwareRT
SoftwareRT

Part and Inventory Search

Sponsor

Back
Top