![]() |
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. |
Right click on the tab and select Delete Sheet
-- John C. Harris, MPA JCZ Consulting Services, LLC |
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. |
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. |
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. |
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. |
.. 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