Renaming a worksheet
- On the Sheet tab bar, right-click the sheet tab that you want to rename, and
then click
Rename
(as shown in figure below). - Select the current name, and then type the new name.
![Renaming a worksheet with right mouse click](/images/84/1.jpg)
OR
- Double click on the tab you wish to rename (as shown in figure below). The worksheet name is highlighted, indicating that it is selected.
- Enter a new name for the worksheet.
![Rename sheet by double clicking its tab](/images/85/2.jpg)
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, clickInsert
, and then clickInsert Sheet
as shown in figure below.
![Inserting a new worksheet](/images/86/3.jpg)
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](/images/87/4.gif)
- Double-click the template for the type of sheet that you want.
![Insert dialog box](/images/89/6.gif)
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](/images/88/5.gif)
Deleting a worksheet
- Right-click the sheet tab of a worksheet, and then click
Delete
OR
![Delete a sheet using right mouse button](/images/90/7.gif)
- On the Home tab, in the Cells group, click
Delete
and thenDelete Sheet
![Delete a sheet using ribbon](/images/91/8.gif)
In confirmation message click Delete
to permanently delete the worksheet and
its data.
![Deleting sheet warning message](/images/92/9.gif)
by
updated