how do you delete sheets in excel but keep your original?

O

Otto Moehrbach

The only way you can delete a sheet and keep it too is to have more than one
file. Use Save-As to create the same file with another name, then delete
the sheet(s) in the copy. HTH Otto
 
B

Bridgette

RWN said:
Right click the sheet tab of the sheets you want to kill and select "Delete".
Click to expand...
the sheets i am trying to delete are not worksheets i opened them under Window /New Window. there is no delete option by right clicking. thank you for your help!
[/QUOTE]
 
N

Norman Jones

Hi Bridgette,

Click the workbook's X icon - not the Excel X icon which is at the top right
of the Excel window.


---
Regards,
Norman



Bridgette said:
the sheets i am trying to delete are not worksheets i opened them under
Window /New Window. there is no delete option by right clicking. thank
you for your help!
Click to expand...
[/QUOTE]
 
B

BizMark

Or, you could right-click on the sheet tab, select 'Move or Copy', then
in the 'Move to where...' pull down the top drop-down and select (new
book).
Make sure that 'Create a copy' is unticked.

The sheet will be removed from your original workbook and will then
occupy a new, separate, untitled workbook.

BizMark
 
Top