Computer and Business Skills training

Sign Up
Home / Excel / Worksheets

Inserting, renaming, and deleting Excel worksheets


These topics are covered in Module 1 in our 1-day Excel Intermediate course.



Inserting New Worksheets


Inserting a new worksheet into a workbook is easy. Excel inserts a new worksheet before the currently selected worksheet.


For Microsoft Excel training in Chicago and Los Angeles give us a call us on 888.815.0604.


Method

To insert a new worksheet:

  1. From the Insert menu, choose Worksheet.
    or
  2. Click the Insert new worksheet button next to the worksheet tabs as show in Figure 1.1

     


Exercise

In the following exercise, you will insert two new worksheets into a workbook

  1. Select the Tuition Generated worksheet from the Latham College workbook.
  2. Click on the Home tab, in the Cells group, click Insert, and then click Insert Sheet. [A new worksheet, Sheet1, is inserted in front of the Tuition Generated worksheet].
  3. Repeat steps 1 and 2 to insert another worksheet in front of the Tuition Generated worksheet. [A second new worksheet, Sheet2, is inserted].


Renaming Worksheets

Once you have created a new worksheet, you can rename it. You can create worksheet names up to 31 characters long, including spaces. The worksheet name cannot be enclosed in square brackets and cannot include the following characters:  colon (:), slash (/), backslash (\), question mark (?), and asterisk (*).

 


Method

To rename a worksheet:

  1. Double-click the worksheet tab.
  2. Type the new worksheet name.
  3. Press Enter


Exercise

In the following exercise, you will rename worksheets.

  1. Double-click the Sheet2 sheet tab. [The Sheet2 sheet tab is selected and the worksheet name is highlighted].
  2. Type Notes.
  3. Press Enter. [The worksheet is renamed Notes].
  4. Double-click the Sheet1 sheet tab. [The Sheet1 sheet tab is selected and the worksheet name is highlighted..
  5. Type Temporary.
  6. Press Enter. [The worksheet is renamed Temporary].


Deleting Worksheets

You can delete a worksheet simply by choosing Delete Sheet from the Cells group on the Home tab. Be very careful, however. Once you have deleted a worksheet from a workbook, you cannot undelete it.



Method

To delete a worksheet:

  1. Select the worksheet to be deleted.
  2. On the Home tab, in the Cells group, click the arrow next to Delete, and then click Delete Sheet.

Note: You can also right-click the sheet tab to view a shortcut menu, from which you can choose Delete.


Exercise

In the following exercise, you will delete one of the worksheets in the workbook.

  1. Make sure the Temporary worksheet is selected.
  2. From the Cells group, choose Delete. [The pop up menu shows tab options].
  3. Choose Delete Sheet. [The Temporary worksheet is deleted and the Notes worksheet is selected].

 

More about our Excel Intermediate class


Other topics covered on this workshop include advanced functions and formulas, charting, advanced formatting and more. Read our testimonials.

There are 4 different levels of Excel training. For more information about what is covered in each level please click on the links below.

We hope to see you on an Excel class soon!


Related Excel Lessons

Working with multiple Excel workbooks
Working with multiple views in Excel
Working with multiple workbooks cont.
MS Excel Workspaces
Excel Formulas
Copying Excel Formulas
Creating Functions in Excel

Excel courses

Why train with us?Need Group training quotation?Fresh Starbucks brewed every day Book two levels of Excel training and save $100FREE Class Repeat with each courseBook 3 Level of Excel Training and save $150