Join Dennis Taylor for an in-depth discussion in this video Renaming, inserting, and deleting sheets, part of Excel Essential Training (Office 365).
- [Narrator] There are a number of reasons at different times for renaming a worksheet, for inserting a new worksheet, deleting a worksheet and occasionally even hiding a worksheet, and of course later unhiding it. We're looking at a workbook called 09 Regional Sales, and the current sheet is the East sheet. I'd like to rename that Midwest sheet. I can right sheet that sheet, it's called Midwest right now. Right click that sheet and rename, and I can certainly start typing, do that right now. Slightly faster, I'll double click that sheet tab, that activates it and I'll just type Central.
Sheet names can have up to 31 characters. Do not begin a sheet name with a number. It can contain spaces and underscores and when we're finished just press Enter. We can easily insert a new sheet. We're about to create a Mountain region here, I want a new sheet to the left of the West sheet. A few different ways to do this as you might guess. We can then choose worksheet which is the automatic selection, click okay. We'll have a new sheet to the left of that sheet. We can also do this when the West is selected. I'll simply press Shift F11.
That also inserts a new sheet. And there's a third way. This will put a new sheet to the right of the current one. There's a plus, typically we see it off to the right of the last sheet tab, keep your eye on that West sheet, we're about to see a new sheet to the right of that. There we are. Now as it turns out I don't need this sheet, this sheet five. I'm going to right click and delete. There's no data in it so there's no warning or second thoughts about that. But what if I decided to delete sheet four and I mistakenly right click on the West sheet? Now this is highly unlikely but occasionally these things happen.
I'm on the path to deleting the West sheet. Now it does have data in it and I get this warning, Microsoft Excel will permanently delete this sheet. Now what this really means is we cannot undo this action. In fact, most actions related to sheet tabs we can't undo. If I click delete here, the West sheet is gone and my only recourse to get that back would be to close the file without saving it. So I'll simply cancel here. So we want to be particularly sensitive. This sheet here I don't need, right click delete. Again, there will be no warning, that's an empty sheet, it has no data.
Same thing with sheet one. As it turns out maybe I don't need that. But maybe I'll come back later and rename it Mountain. From time to time you might need to hide a sheet. Now possibly others use this workbook or maybe I use it for demo purposes but I don't need this to be showing here. So we can right click a sheet tab and hide a sheet. At a later time if we need to get that back we don't have to be near where that sheet was hidden but we can go to another sheet tab, any sheet tab, right click, if Unhide is selectable that means there is at least one hidden sheet.
We'll click on Hide. If you've got multiple hidden sheets, you can only unhide one at a time. So at some point maybe I want to unhide this, click okay and there it is back again in it's previous location. So as we've seen it's easy to rename a sheet typically by double clicking. We can insert a sheet in a variety of different ways. From time to time we will delete a sheet being very careful about not being able to undo, and occasionally hide and unhide worksheets.
- Working with the Excel interface
- Entering data
- Creating formulas and functions
- Formatting your data
- Adjusting rows and columns
- Finding and replacing data
- Inserting and deleting sheets
- Sorting and filtering data
- Creating charts and PivotTables
- Printing and sharing worksheets
- Protecting worksheets and workbooks
Skill Level Beginner
Q: This course was updated on 1/7/2019. What changed?
A: A new video was added that covers working with Excel Ideas.