By default, Excel gives you one worksheet in a workbook, but you can add more worksheets, rename them, or delete them, as needed.
Do one of the following:
On the Sheet tab, select . A new worksheet will be added to the right of the current sheet.
Select Home > Insert > Insert Sheet.
Right-click a sheet, click Insert, and in the Insert box, click Worksheet, and then click OK.
On the Sheet tab, right-click the worksheet you want to rename, and then click Rename.
Type a new name for the Sheet, and then press Enter.
Tip: Double-click the sheet name on the Sheet tab to quickly rename it.
On the Sheet tab, right -click the sheet you want to delete.
Click Delete .
If the sheet is empty, it will be Deleted, but if there is data on the sheet, then a pop-up message will appear. Select Delete to confirm the deletion.
On the Sheet tab, right -click the sheet you want to hide.
We can easily rename sheets.
One way is to right click a sheet tab and then rename, and at that point we can start typing, but it's simply faster to double click it.
Let's double click Sheet3 and call it performance scores or annual scores.
You can have spaces in the sheet tab name, you can use up to 31 characters.
When you use formulas that refer to sheet names those that have spaces in them also use automatically embedded single quotes, it might make some formulas look a little bit more complex, but there's nothing really wrong with a space in a sheet name, and sometimes it improves readability.
Again, change a sheet name, simply double click and start typing. We can also insert a sheet at any time and there's some quick ways to do that too.
If we're about to put in a new region here, say a mountain region between South and West, we could if we wanted to right click on the West sheet and choose Insert and go down that path and certainly nothing wrong with that, there's worksheet, click okay, and so on, we can do that.
But there are two short cuts. If we want a sheet to the left of west we can press shift + F11, so watch the sheet tabs as I press shift + F11, to the left of West we're gonna see something.
And there it is, a Sheet3. Now at other times we might want a sheet to the right, maybe we're going to have an international group after West so we can click West.
If we want a sheet to the right of that there's a plus out here, just beyond the last sheet name. You'll see it out here, a single plus, new sheet.
That adds a sheet to the right of the current active sheet.
As it turns out we might not need this.
I'm going to right click and delete a sheet.
There's nothing in the sheet so there's no warning.
However, if you try to delete a sheet that has data in it, you will get a warning.
And it's somewhat of a strong warning.
Suppose I right click on Annual Scores, I'm on the path, maybe this is a mistake or maybe I really want to get rid of it, but when I click DeleteExcel stops because there's data in it and says Microsoft Excel will permanently, and I'm emphasizing it, permanently delete this sheet.
Do you want to continue? If I click Delete, I will not be able to use the undo capability to get this back.
Now what I possibly could do is close this file without saving it if I mistakenly deleted this.
But, what if I've done a lot of good things along the way without saving? Those are all going to be lost.
So a strong warning here.
Don't delete a sheet unless you really are sure of it.
In fact, most of the features that we see when we right click a sheet tab cannot be undone.
Learning doesn't stop here. Discover more expert led tutorials at LinkedIn Learning. Start your free trial today, at linkedin.com/learning.
Learn from recognized industry experts, and get the business, tech, and creative skills that are most in demand.Benefits
Get unlimited access to over 4,000 video courses.
Receive personal recommendations based on your LinkedIn profile.
Stream courses from your computer or mobile device.
Take courses for every level – beginner to advanced.
Practice while you learn with quizzes, exercise files, and coding windows.
Choose a plan for yourself or your entire team.