You are able to double-click a sheet tab to change its name. To insert a new sheet, press Shift+F11. You can also right-click a sheet tab and click Delete to remove it.
- [Instructor] You can easily control a workbook's structure by renaming sheets, inserting new worksheets when needed, and deleting worksheets when they're no longer needed. We're looking at a workbook called 09 - RegionalSales, and at the moment we're looking at a sheet called East. I'm gonna click on the Midwest sheet, South sheet, West sheet, Performance Scores, that's a completely different choice. We might want to add a new sheet. Most sheet tab commands are available at the bottom of the screen, simply by right clicking an existing sheet.
So for example, if we simply right click a sheet tab, we see the choice called Rename. And that simply activates the text and we can type in a completely new entry, or click in here and do some editing if we want to make a change. Nothing wrong with that, but it's a lot simpler and easier to simply double click. I want to change that sheet name to simply be Scores. I'll double click, the cursor's at a certain point in there, I'll use Backspace or Delete and readjust that. Sheet names can be up to 31 characters. You can use spaces.
I finally have this looking the way I want. I'll simply press Enter. I want to change the name West to Pacific. It's the next sheet tab to the left. I'll click it, then double click it, and type in Pacific, and enter. So it's easy to change the name of a sheet. I want a new sheet now and here, too, I could be right clicking and choosing Insert, and I'll probably choose Worksheet and OK. There are some other variations out here that most of you probably wouldn't need, but that's available, too. So that's an easy technique, but even here there are a couple of other techniques.
I don't need this sheet for the moment. I might not need it ever, but how do we get rid of a sheet? You probably guessed it, right click and Delete. There's nothing in that sheet, no prompt whatsoever about the concern of getting rid of it. Now suppose I want a new sheet. We're gonna restructure these regions here. We might be having a Mountain region eventually. We're gonna regroup some of these. We saw how we could right click a sheet tab and come to Insert. Another technique is simply a keystroke shortcut, Shift + F11. Keep an eye on that Pacific sheet.
Shift + F11, what do we now see to the left of it? Sheet10 in this case. Now, that will vary, the name of the sheet, but it will be a temporary name, Sheet1, Sheet2. I've been moving around a lot, adding sheets, taking them out, so this is a higher number than we'd typically see, but that's easily handled. Simply press Shift + F11 to add a new sheet. There's another way. Suppose I wanted a sheet to the right of Pacific. Over here, after the last sheet tab, you'll see a plus symbol, slide over it, says New sheet.
As I click this, watch a new sheet appear to the right of Pacific, and there we see that one. Now, when you delete an empty sheet, there's no prompting whatsoever, so I'll right click Sheet11 and Delete. No prompt because there was no data. Same thing on Sheet10, I decided I don't need that. Right click, Delete. But I also don't need this Scores sheet any more. I'll right click and Delete. But because there is data, here's a prompt. And although the wording isn't exact, it's pretty strong. Microsoft Excel will permanently delete this sheet.
What does that really mean to us? We cannot use the Undo feature to get this sheet back. So if I click Delete here, it's gone. Now, if I'm in panic mode right now, what could I do? I could close the file and not save it, then reopen it, and that sheet would be there. But often when that need occurs, we've done a lot of other good things in the meantime, and those things would not be saved either. So be very alert to the idea when you delete a sheet, you want to be sure that you truly want to get rid of it. And so we've seen multiple techniques for renaming sheets, inserting sheets, and deleting sheets, vital tasks as you work with Excel.
- Navigating Excel tabs and menus
- Entering data
- Creating formulas and functions
- Formatting rows, columns, cells, and data
- Working with alignment and text wrap
- Adjusting rows and columns
- Finding and replacing data
- Printing and sharing worksheets
- Creating charts and PivotTables
- Inserting and deleting sheets
- Using power functions such as IF and VLOOKUP
- Password-protecting worksheets and workbooks
- Sorting data
- Analyzing data with Goal Seek and Solver
- Creating and running macros