ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I save only active worksheet without save all of worksheet (https://www.excelbanter.com/excel-worksheet-functions/221851-how-do-i-save-only-active-worksheet-without-save-all-worksheet.html)

droth

How do I save only active worksheet without save all of worksheet
 
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.

David Biddulph[_2_]

How do I save only active worksheet without save all of worksheet
 
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.
--
David Biddulph

droth wrote:
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.




Dave Peterson

How do I save only active worksheet without save all of worksheet
 
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.

droth wrote:

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.


--

Dave Peterson


All times are GMT +1. The time now is 01:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com