How do I save only active worksheet without save all of worksheet

D

droth

Excel 2003
I have formatted copy of existing worksheet and inserted in to new worksheet
tab.
I do not want the worksheet I edited to change from orginal content.
I am unsure how to save only the active worksheet with out saving the others.
 
D

David Biddulph

Save will save a workbook, not a worksheet.
It sounds as though you need to move your new worksheet into a new workbook
and save that.
If you want a copy of that added as an extra sheet to your original
workbook, close the original book without saving, then reopen and copy from
your new workbook into your old one.
 
D

Dave Peterson

If that worksheet is going to be used as a template, you may want to just hide
that sheet. Most users won't know where to look or even care.

Select the sheet to hide
Format|sheet|hide

Just unhide it when you need to use it to make another copy.
 

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

Top