| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is the quickest method to insert & name multiple worksheets . | Excel Worksheet Functions | |||
| Extracting data from multiple worksheets into a list | Excel Worksheet Functions | |||
| how do I sum the same cell from multiple worksheets? | Excel Worksheet Functions | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
| Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
