ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   HOW DO I DELETE A WORKSHEET IN EXCEL? NOT HIDE IT OR RENAME IT (https://www.excelbanter.com/excel-worksheet-functions/32369-how-do-i-delete-worksheet-excel-not-hide-rename.html)

deborah.hill

HOW DO I DELETE A WORKSHEET IN EXCEL? NOT HIDE IT OR RENAME IT
 
I have a workbook that has several sheets in it that I want to delete. I
don't want to hide them or rename them. I want to DELETE THEM.

John C. Harris, MPA

Right click on the tab and select Delete Sheet

--
John C. Harris, MPA
JCZ Consulting Services, LLC



Jennie

right click on the tab and one of the options will be "delete". OR go to
"Edit," "Delete Sheet"

"deborah.hill" wrote:

I have a workbook that has several sheets in it that I want to delete. I
don't want to hide them or rename them. I want to DELETE THEM.


deborah.hill

That is the problem. When I go to Edit and hit Delete the only options are
available are delete row or delete column. There is no "delete sheet"
option.

"Jennie" wrote:

right click on the tab and one of the options will be "delete". OR go to
"Edit," "Delete Sheet"

"deborah.hill" wrote:

I have a workbook that has several sheets in it that I want to delete. I
don't want to hide them or rename them. I want to DELETE THEM.


Ron de Bruin

Hi deborah

Right click on the sheet tab and click on Delete


--
Regards Ron de Bruin
http://www.rondebruin.nl


"deborah.hill" wrote in message ...
I have a workbook that has several sheets in it that I want to delete. I
don't want to hide them or rename them. I want to DELETE THEM.




Jennie

under "Edit" check to see if all the options are showing. the delete sheet
option has to be there. Or just right click on the tab and click delete

"deborah.hill" wrote:

That is the problem. When I go to Edit and hit Delete the only options are
available are delete row or delete column. There is no "delete sheet"
option.

"Jennie" wrote:

right click on the tab and one of the options will be "delete". OR go to
"Edit," "Delete Sheet"

"deborah.hill" wrote:

I have a workbook that has several sheets in it that I want to delete. I
don't want to hide them or rename them. I want to DELETE THEM.


Max

.. When I go to Edit and hit Delete the only options are
available are delete row or delete column.
.. There is no "delete sheet" option.


Perhaps try:
Tools Protection Unprotect Workbook ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----




All times are GMT +1. The time now is 02:24 AM.

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