We had a scenario recently where we wanted to delete all hidden sheets in an excel file. There are various ways to remove them. The easiest and most simplest way to do is to use the option "Inspect Option".
MS Excel 2007
Step 1: Click on Office button on the top left
Step 2: Click on PrepareàInspect Document
Step 3: If the file is not saved you will be prompted to save the file. Note one cannot proceed without saving the file.
Step 4: Select only Hidden Worksheets Check box and click Inspect
Step 5: Excel will display number of hidden worksheets in the file. Click Remove All to delete all sheets or click Reinspect to go back to Step 4
Step 6: Excel will display a status message
Note: You cannot use UNDO if you use this option
Regards,
bjayakar
MS Excel 2007
Step 1: Click on Office button on the top left
Step 2: Click on PrepareàInspect Document
Step 3: If the file is not saved you will be prompted to save the file. Note one cannot proceed without saving the file.
Step 4: Select only Hidden Worksheets Check box and click Inspect
Step 5: Excel will display number of hidden worksheets in the file. Click Remove All to delete all sheets or click Reinspect to go back to Step 4
Note: You cannot use UNDO if you use this option
Regards,
bjayakar
