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.

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.

 

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.

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.

• Double-click the template for the type of sheet that you want.

 

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).

Deleting a worksheet

• Right-click the sheet tab of a worksheet, and then click Delete OR

 

• On the Home tab, in the Cells group, click Delete and then Delete Sheet

 

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