Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

In a new Microsoft Excel workbook (2010) I have three sheets by default. Suppose that I suddenly press the Insert worksheet button next to the Sheet3, so the forth sheet will become added to the list of the sheets. But I like to have only three sheets, that is, I want to revert the situation to its previous state. I know how to hide or delete that sheet and also close the workbook without saving the changes. But I don't want them. I like to undo (which of course undo/ctrl+z doesn't work for this case) the work to have the before list of sheets. Is there a way?

share|improve this question

closed as unclear what you're asking by Julian Knight, Raystafarian, Moses, Sathya May 12 at 9:46

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

    
Use Libreoffice - then ctrl+Z will work. –  suspectus May 4 at 9:25
    
Do you mean that every time you add a new sheet, you want the oldest sheet to be automatically deleted, so the number of sheets is always kept to three? –  Garrulinae May 4 at 10:29
    
@Garrulinae: No I want to know whether is there any way to return the before circumstances (Sheet1, Sheet2, Sheet3). Not automatically deleting or like this. –  abbasi May 4 at 13:00
    
This question appears to be off-topic because it is easily answered by a Google search. Too trivial. –  Julian Knight May 4 at 17:25
    
Frankly, asking a question to which you know there are several possible answers and then excluding them all because "I don't want to do it in any of the normal ways anyone would do that" does not make this a valid question. –  AdamV May 7 at 21:26

3 Answers 3

up vote 3 down vote accepted

You cannot 'undo' creating a worksheet in Excel. You will have to delete it.

If you don't want to use your mouse, you can use the shortcut Alt+E then L (Alt+E leads to 'Edit' and L to delete) to delete the current worksheet, which will be the one you just inserted if you accidentally did so.

share|improve this answer
    
OK Jerry. The case I was looking for was that comment of you, You cannot 'undo' creating a worksheet in Excel. You will have to delete it., not the rest. Anyway I think it's possible. Thanks. –  abbasi May 5 at 5:54
    
But also bear in mind if there is only one way of undoing it, it's closing that Excel file without saving the changes. –  abbasi May 5 at 5:58
    
@abbasi I wouldn't call that undoing, I would call that not saving changes :) Because you would also lose anything you did between your last save and the closing of the workbook. It might be possible, but I would think that you will need to write a script for that, certainly not my field of expertise :( –  Jerry May 5 at 6:36
1  
"I think it's possible" - why on earth would you think that? Just because you wish it was true? –  AdamV May 7 at 21:27

Right-click on the tab for the sheet you want to delete. There is a menu item to delete the sheet.

Really though, a Google search would have shown you this, not a good question for SuperUser.

share|improve this answer
    
I think you haven't read my question properly. If you would look at it correctly I SAID "I don't want them.". Deleting a sheet is one the simplest works on Excel. I asked something else. –  abbasi May 5 at 5:51
    
Perhaps because the question is a little odd. if you accidentally add a sheet, delete it again. If you really want to go to town, write a macro that overloads the SAVE function and deletes any empty sheets before saving the workbook. Rather serious overkill though just to cope with an occasional slip of the finger. –  Julian Knight May 5 at 17:05

If you go to File and then Options and look in the General section of options you'll find a heading for "When creating new workbooks" that has a selection for "Include this many sheets" which you can set to 1. Once this is set new workbooks will open with only a single worksheet.

enter image description here

share|improve this answer
    
Really I'm in doubt was I writing this question here in English language or in Chines language! –  abbasi May 5 at 5:52
    
Please read how to ask a good question. 讲清楚帮助别人明白你说什么。 –  Jason Aller May 5 at 16:52
    
It's because it is such a strange question I think. –  Julian Knight May 5 at 17:06

Not the answer you're looking for? Browse other questions tagged or ask your own question.