In this section, we're going to talk about managing your worksheets in your Excel file. Go from managing worksheets to mastery of Excel with Excel classes & bootcamp in NYC or online.
Worksheets
There are several things you can do with worksheets. There's 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 at a high to 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.
Insert Worksheet
First, if you would like to insert any 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 worksheet's tab. If I click on this plus sign, I instantly add a new worksheet. Now, if I wanted to delete a worksheet, what I can do is simply go and right-click and 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 dropdown, 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. I'm going to do it from the same location. Just one command over. I'll click the dropdown for delete and she's delete sheet and the current sheet that I'm on will be deleted. Another way to add a sheet is to right-click and she inserts. You'll get to choose the type of sheet. There are certain different templates, you can insert a charge sheet.
You can insert a sheet for macros and one with a user form. I'm going to or a dialog box. What I'm going to do is select worksheet. There.
Deleting/Hiding Sheets
I want to be able to now delete the sheet. We'll use our first option, which is the right-click option. And then I'll choose to delete my notes, 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 she's hired. And now that she is hidden. Now, if I want to reveal the worksheet, I can right-click on any sheet and she's on hide.
I will see the sheet that I want to hide. 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 incertain delete this time. All the reformat from format in the visibility section we have hired and on hide. This is all also available for rows and columns, but we're gonna choose to hide a sheet and now it's hidden.
And if I want to reveal the sheet, I can go to the same location, go to format.
And then on hide and hide, I want to choose on hide sheet. And when I click there.
I'll see the dialog box where I can choose the sheet that I want to hide. I'll only be able to hide one sheet at a time if I have multiple sheets. I can't just like the mall and, um, hide 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.
Copying Sheets
If I want to copy a sheet. I can simply right click and choose. Move or copy.
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 and then I'm going to choose a location where I want that copy to go. I wanted 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 worksheets and this will move this worksheet from this position to write in right before worksheets. One click on OK. And I've moved that sheet. It is no longer in its original position.
Moving Sheets
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 a move or a copy that will simply bring up the same dialog box that we brought up before you go through the same steps. Here's a much easier way, though, to move. Recopy a sheet if you want to copy it. 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 control key.
Click and then drag, they'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, click and drag it and you can change its position. So 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. Start to type in your name.
Naming Sheets
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 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. 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 and right-click or click and drag.
Other Locations for Excel Training
Learn Excel from the comfort of your home with live online training from anywhere or have us come to your offices anywhere in the US for corporate training in Excel. Learn more about Excel training in your location: