Watching:

Rename, Insert, and Delete Excel Sheets


show more Renaming, inserting, and deleting sheets provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2013 Essential Training show less
please wait ...

Renaming, inserting, and deleting sheets

We're using the workbook 09-02-RegionalSales. The sheet names are appropriate except for Sheet3 and so changing the name of the sheet is something you want to be able to do quickly and easily. You can access many features related to sheet tabs simply by Right-Clicking a sheet and that brings up a menu. Here, of course, is a choice for Rename. It's much faster, however, simply to Double-Click a sheet tab. This Sheet3 for example contains Annual Performance Scores. It contains some sparklines in column H . Let's just change the name of it by Double-Clicking and we could type anything we want.

Why not Annual Scores? You can have spaces in sheet names. They can be up to 31 characters. Simply type in the name you wish and press Enter. If we need to add a new sheet, we can simply Right-Click and we're about to insert a new sheet. If we choose Worksheet here and then OK, a worksheet just to the left of the sheet that had been selected. But there are two faster ways, if we want a new sheet to the right of any worksheet, suppose we're going to add a new region between South and West. Maybe it's going to be a mountain region.

We want a new sheet to the right of South here. Click the South tab and then to the right of our sheet names, we'll see a plus, simply Click New Sheet and we got a new sheet here called Sheet4, which we will rename eventually, Mountain. And there's the keystroke shortcut method as well. We might want to put a summary sheet to the left of the East sheet. If you press Shift+F11, you will automatically get a new sheet to the left of the current sheet. All sheet actions, except for changing tab colors, cannot be undone or you cannot use the Undo feature.

That's particularly meaningful if you're about to delete a sheet. Maybe I'm not thinking too clearly or maybe the thought has occurred to me that I don't need this sheet, I Right-Click and choose Delete and now I see this message, You can't undo deleting sheets. You might be removing some data. If you don't need it, Click Delete. It is a strong warning and so if I were to press Delete here, I can't use the Undo capability to bring back that sheet. What I might need to do in a case like that if I had second thoughts, is simply close the file without saving it and then reopen it.

Of course sometimes that happens after you've done a lot of good things along the way. So you want to be very careful about deleting sheets. So as we've seen, we can rename sheets, we can insert sheets, we can delete sheets either by Right-Clicking or using some of the shortcuts I suggested.

Renaming, inserting, and deleting sheets
Video duration: 2m 23s 6h 32m Appropriate for all

Viewers:

Renaming, inserting, and deleting sheets provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2013 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...