Managing Excel Worksheets with Ease

Worksheets. In this section, we're going to talk about managing your worksheets in your Excel file. There are several things you can do with worksheets.

This is going to be similar to our rows and columns section. I'm going to show you how to insert a new worksheet, how to delete a worksheet, how to hide a worksheet, how to copy and move your worksheets throughout the Excel workbook, and also how to change your worksheet name. So let's get started.

First, if you would like to insert a new worksheet, the easiest way to do this is to simply click on the plus sign right after the last worksheet. So currently, I'm on the worksheets tab. If I click on this plus sign, I instantly add a new worksheet.

Now if I want to delete a worksheet, what I can do is simply right-click and choose Delete, and that deletes the worksheet. What's another way that you can insert a worksheet? Well, you can go to the Home tab. You can head all the way over to the Cells group, and in the Cells group, you'll see a command Insert.

If you click the drop-down, you can choose to insert a new sheet. It's right under Insert Sheet Columns. When I click there, I've inserted a new sheet.

I want to delete the sheet that I just created, and I'm going to do it from the same location, just one command over. I'll click the drop-down for Delete and choose Delete Sheet, and the current sheet that I'm on will be deleted. Another way to add a sheet is to right-click and choose Insert.

You'll get to choose the type of sheet. There are several different templates. You can insert a chart sheet.

You can insert a sheet for macros and one with a user form or a dialog box. What I'm going to do is select Worksheet. There, I want to delete the sheet now.

We'll use our first option, which is the right-click option, and then I'll choose Delete. Now, let's take a look at hiding worksheets. I have a sheet that I would like to hide.

This is going to be available to me from the right-click. Just right-click and choose Hide, and now that sheet is hidden. Now, if I want to reveal the worksheet, I can right-click on any sheet and choose Unhide.

I’ll see the sheet that I want to unhide. I'll click OK, and that will reveal it. The other way that you can hide the sheet is also using the ribbon.

You'll go to the Home tab. You’ll head all the way over to the Cells group. You’re not going to worry about Insert and Delete.

This time, we'll go to Format. From Format, in the Visibility section, we have Hide and Unhide. This is also available for rows and columns, but we're going to choose to hide a sheet, and now it's hidden.

If I want to reveal the sheet, I can go to the same location, go to Format, then Unhide. I want to choose Unhide Sheet, and when I click there, I'll see the dialog box where I can choose the sheet that I want to unhide. I can only unhide one sheet at a time.

If I have multiple sheets, I can't just select them all and unhide them all at the same time, so bear that in mind. I'll click OK, and now I've unhidden the sheet. Next thing we'd like to do with our sheets is copy the sheet.

If I want to copy a sheet, I can simply right-click and choose Move or Copy. Now, the only thing that's going to determine whether or not I move or copy a sheet is whether or not this checkbox is checked. If it's checked, I'm creating a copy.

If it's not checked, I'm moving it, so I'm going to create a copy. Then I'm going to choose the location where I want that copy to go. I want it to go right before the sheet worksheets, so as soon as I click OK, I've created a copy of the Copy Me sheet right before worksheets. I'm going to delete this, and now let's take a look at moving.

I'll go to that Worksheet tab, right-click, I'll choose Move or Copy. This time I will not click the checkbox for Create Copy. I'll simply choose the Worksheets workbook, and this will move this worksheet from this position to right before worksheets.

One click on OK, and I've moved that sheet. It is no longer in its original position. So that's one way of going about it.

You can also go to the Home tab. If you go to the Home tab, what will happen is you will choose Move or Copy. That'll simply bring up the same dialog box that we brought up before.

You'll go through the same steps. Here's a much easier way, though, to move or copy a sheet. If you want to copy a sheet, let's start with moving.

If you want to move a sheet, you'll simply click and drag, and that allows you to move the sheet. If you want to copy the sheet, then what you'll do is press the CTRL key, click, and then drag. There'll be a little plus sign on something that looks like a page, and that makes a copy.

Again, to move, simply click on the worksheet you want to move, then click and drag it, and you can change its position. Now that we've taken a look at those options, we'll take a look at changing the worksheet name. You can do this by simply double-clicking on the sheet that you want to change the name for, and then you can use your arrow key to place your cursor exactly where you want to start to type a new name.

So I'm going to say Change Name of This Worksheet, and then I'll press ENTER. I can also right-click and choose Rename. Now you want to make sure that you don't start typing now, or you'll just overwrite the existing information.

As soon as I click Change Name, if I start typing, it erases everything that's there. That's why you might want to use the cursor to go to a specific position within the existing name if you're just making a slight edit. So that's how you can manage worksheets in your workbook.

It’s pretty simple. You'll have a couple of right-click options. You'll also be able to go to the ribbon and use the menu there, but it's much easier to go directly to the sheet, right-click, or click and drag.