Can you delete multiple worksheets with one command?
 

I accidentally added over a hundred new worksheets to an already large
workbook. Is there a way to get rid of them as easily as I created them?

select the first onehold down the shift keyselect the lastdeletegone

--
Don Guillett
SalesAid Software

"pebel" wrote in message
...
I accidentally added over a hundred new worksheets to an already large
workbook. Is there a way to get rid of them as easily as I created them?

Select first sheet to delete then hold SHIFT key and select last sheet to
delete.

Right-click on sheet tab and "Delete".

Answer yes to prompt and all selected sheets will be gone.


Gord Dibben Excel MVP

On Thu, 17 Mar 2005 14:29:07 -0800, "pebel"
wrote:

I accidentally added over a hundred new worksheets to an already large
workbook. Is there a way to get rid of them as easily as I created them?