Microsoft Excel

Inserting, deleting and renaming worksheets

  1. Renaming a worksheet
  2. Inserting a worksheet
  3. Deleting a worksheet

Renaming a worksheet

  1. On the Sheet tab bar, right-click the sheet tab that you want to rename, and then click Rename (as shown in figure below).
  2. Select the current name, and then type the new name.
Renaming a worksheet with right mouse click

OR

  1. Double click on the tab you wish to rename (as shown in figure below). The worksheet name is highlighted, indicating that it is selected.
  2. Enter a new name for the worksheet.
Rename sheet by double clicking its tab 

Press enter key. The new worksheet name will be displayed on the worksheet tab at the bottom the screen.

Inserting a worksheet

By default, MS Excel provides three worksheets in a workbook, but you can insert additional worksheets or delete them as needed. You can also change the number of worksheets that appear by default in a new workbook.

To insert a new worksheet, do one of the following:

To insert a new worksheet in front of an existing (active) worksheet, select that worksheet and then, on the Home tab, in the Cells group, click Insert, and then click Insert Sheet as shown in figure below.
Inserting a new worksheet

OR

If you want to insert a new sheet that is based on a custom template then

  • Right-click the sheet tab of a worksheet, and then click Insert.
Inserting new sheet using right mouse click
  • Double-click the template for the type of sheet that you want.
Insert dialog box 

OR

To quickly insert a new worksheet at the end of the existing worksheets, click the Insert Worksheet tab at the bottom of the screen (see figure).
Insert a worksheet quickly

Deleting a worksheet

  • Right-click the sheet tab of a worksheet, and then click Delete OR
Delete a sheet using right mouse button 
  • On the Home tab, in the Cells group, click Delete and then Delete Sheet
Delete a sheet using ribbon 

In confirmation message click Delete to permanently delete the worksheet and its data.

Deleting sheet warning message
by BrainBellupdated
Advertisement: