Right click the sheet tab of the sheets you want to kill and select "Delete".

--
Regards;
Rob
------------------------------------------------------------------------
"Bridgette" wrote in message
...

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
"RWN" wrote in message
...
Right click the sheet tab of the sheets you want to kill and select
"Delete".

--
Regards;
Rob
------------------------------------------------------------------------
"Bridgette" wrote in message
...

"RWN" wrote:

Right click the sheet tab of the sheets you want to kill and select "Delete".

--
Regards;
Rob
------------------------------------------------------------------------
"Bridgette" wrote in message
...

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!

Hi Bridgette,

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 the workbook's X icon - not the Excel X icon which is at the top right
of the Excel window.


---
Regards,
Norman



"Bridgette" wrote in message
...


"RWN" wrote:

Right click the sheet tab of the sheets you want to kill and select
"Delete".

--
Regards;
Rob
------------------------------------------------------------------------
"Bridgette" wrote in message
...

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!

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

"RWN" wrote:

Right click the sheet tab of the sheets you want to kill and select "Delete".

--
Regards;
Rob
------------------------------------------------------------------------
"Bridgette" wrote in message
...

Thank you i will do that!