Locked lesson.
About this lesson
Renaming, adding, deleting, moving and copying sheets.
Exercise files
There are no related exercise files for this lesson.
Quick reference
Workbook Management
Renaming, adding, deleting, moving and copying sheets.
When to use
Learn how to change the name of an Excel worksheet, and what to remember when deleting sheets. Learn quick ways of moving and duplicating sheets.
Instructions
Rename a sheet
Double-click on the sheet name and type the new sheet name
Add a new sheet
Click the plus sign (+) to the right of the last sheet
Delete a sheet
Right-click on the sheet name and select “Delete” from the menu options
Move a sheet
Method 1
Click on the name of the sheet, then drag and drop to the new desired location.
Method 2
- Right-click on the sheet name and select “Move or Copy” from the menu options
- Select the workbook (if other than the current workbook) where you want the sheet to be moved to
- Select the sheet you want your worksheet to appear in front of
Copy a sheet
- Right-click on the sheet name and select “Move or Copy” from the menu options
- Select the workbook (if other than the current workbook) where you want the sheet to be copied to
- Select the sheet you want your worksheet to appear in front of.
- Check the ‘Create a copy’ checkbox
- 00:04 The default Excel sheet name is Sheet1, but we can give it a more descriptive name
- 00:09 just by double clicking, and typing the new name straight into the sheet tab.
- 00:14 Let's double click, and call this sheet Suppliers.
- 00:22 We can add a new sheet by clicking on the + sign to the right of the last
- 00:26 sheet name.
- 00:26 Our new sheet is called Sheet2, and we click and we get Sheet3.
- 00:32 We can also move sheets around by clicking on the sheet tab and then dragging and
- 00:37 dropping.
- 00:37 So let's click on the Suppliers sheet, and we notice that when we drag a worksheet,
- 00:44 we'll see a small arrow to indicate the new location of the sheet.
- 00:49 We release, and our sheet is moved, what if you want to delete a sheet?
- 00:51 That's easy too, we right click on the sheet name,
- 00:57 we click Delete, and it's gone.
- 01:02 If there's a data on your sheet and you try to delete, Then you'll get a warning
- 01:08 saying, Microsoft Excel will permanently delete the sheet, do you want to continue?
- 01:13 If you do want to continue then press Delete, otherwise press Cancel.
- 01:17 There's no way to undo deleting a sheet, clicking Undo won't bring it back.
- 01:23 So make sure before you hit Delete,
- 01:25 that you don't want the information on this sheet.
- 01:28 So we don't want to Delete our sheet here, we hit Cancel, and like we said,
- 01:32 if there's no data, then it will delete without warning.
- 01:36 The options to insert, rename, or move sheets are also available
- 01:41 when we right click on the sheet name at the bottom of our workbook.
- 01:46 So if we didn't want to drag and drop or double click,
- 01:51 we could right click, and Insert, Delete or Rename our sheet.
- 01:57 Let's explore the Move or Copy option, selecting Move or Copy sheet
- 02:02 gives us a dialog box where we can choose where we want the sheet to be moved to.
- 02:08 So we can move our sheet to a new book to an existing book that's open at the time
- 02:13 that we're performing this action, or somewhere else within this workbook.
- 02:18 If we want to copy this sheet then we click on the checkbox that
- 02:23 says create a copy, and the same options are available.
- 02:27 We can create a copy of this sheet and put it in a brand new workbook, in an existing
- 02:32 workbook that's currently open, or in the current workbook that we're working on.
- 02:36 The default is to put it in the current workbook, and then we tell Excel exactly
- 02:41 where within that workbook we'd like our copied sheet to be placed.
- 02:44 Do we want it before this sheet, or do we want it at the end?
- 02:49 Let's see what it would look like if we created a copy of the sheet,
- 02:54 Excel has made an exact copy, so
- 02:57 both sheets have the same data, they look the exact same.
- 03:01 But the name of the copied sheet now has the name of the original sheet,
- 03:05 with the number (2) in parentheses
Lesson notes are only available for subscribers.