| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
Right click on the tab and select Delete Sheet
-- John C. Harris, MPA JCZ Consulting Services, LLC |
|
#3
|
|||
|
|||
|
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. |
|
#4
|
|||
|
|||
|
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. |
|
#5
|
|||
|
|||
|
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. |
|
#6
|
|||
|
|||
|
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. |
|
#7
|
|||
|
|||
|
.. 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 ---- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
| How do I make formula in Excel from other worksheet? | Excel Worksheet Functions | |||
| Copying blank excel worksheet into additional excel workbooks | Excel Discussion (Misc queries) | |||
| How to link Excel worksheet tab names to dates in each worksheet? | Excel Worksheet Functions | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
Linear Mode
