Chapter 3

Section 3.2 – Moving, Renaming, Inserting, and Deleting Worksheets

Learning Objectives

  1. Understand how to move, rename, insert, and delete worksheet tabs.

FILE: CH 3.2

The default names for the worksheet tabs at the bottom of workbook are Sheet1, Sheet2, and so on. However, you can change the worksheet tab names to identify the data you are using in a workbook. Additionally, you can change the order in which the worksheet tabs appear in the workbook. The following steps explain how to rename and move the worksheets in a workbook:

Open file CH 3.2

  1. With the left mouse button, double click the Sheet1 worksheet tab at the bottom of the workbook (see Figure 3.9). Type the name Sales by Month.
  2. Press the ENTER key on your keyboard.
  3. With the left mouse button, double click the Sheet2 worksheet tab at the bottom of the workbook.
  4. Type the name Unit Sales Rank to prepare the worksheet for future use.
  5. Press the ENTER key on your keyboard.
image
Figure 3.9 Renaming a Worksheet Tab
  1. Click the Sheet3 worksheet tab.
  2. Click the Home tab of the Ribbon.
  3. Click the down arrow on the Delete button in the Cells group of commands.
  4. Click the Delete Sheet option from the drop-down list. This removes the unneeded worksheet.
  5. Click the Delete button on the Delete warning box (if a warning box appears).
  6. Complete the steps above to delete the newly named Unit Sales Rank worksheet since it’s decided that worksheet is also unnecessary so that you are left with just one worksheet (see Figure 3.10).
  7. Save the changes to your workbook by clicking either the Save button on the Home ribbon; or by selecting the Save option from the File menu.
image
Figure 3.10 Completed View of the Renamed Worksheet Tab

Integrity Check

Deleting Worksheets

Be very cautious when deleting worksheets that contain data. Once a worksheet is deleted, you cannot use the Undo command to bring the sheet back. Deleting a worksheet is a permanent command.

Keyboard Shortcuts

Inserting New Worksheets:

  • Press the SHIFT key and then the F11 key on your keyboard.

Skill Refresher

Renaming Worksheets:

  1. Double click the worksheet tab.
  2. Type the new name.
  3. Press the ENTER key.

Moving Worksheets:

  1. Left click the worksheet tab.
  2. Drag it to the desired position.

Deleting Worksheets:

  1. Open the worksheet to be deleted.
  2. Click the Home tab of the Ribbon.
  3. Click the down arrow on the Delete button.
  4. Select the Delete Sheet option.
  5. Click Delete on the warning box.

License

Icon for the Creative Commons Attribution 4.0 International License

COM112: Course Text Copyright © 2020 by The American Women's College is licensed under a Creative Commons Attribution 4.0 International License, except where otherwise noted.