Articles → EXCEL → Insert And Delete Worksheets In Excel

Insert And Delete Worksheets In Excel

In this article I will explain how to insert and delete worksheets in excel.

Software Requirement

Before you start reading this tutorial you should make sure that excel 2007 (or 2010) is installed on your machine.

Before you go ahead, it is required that you should know basics about excel.

First of all open a new excel and save it with the name ‘Insert_Delete_worksheets_Demo.xlsx’ (you can give any name).

To add a worksheet

Method 1 –
1. Select any worksheet
2. Right click on any worksheet and click ‘Insert’
3. A popup appers as shown in figure below
4. Select ‘Worksheet’
5. Click ‘Ok’
Method 2 –
1. Select any worksheet
2. Click on ‘Insert Sheet’ option of ‘Insert’ button

Click to Enlarge

Once you have inserted the sheet the excel will look like

To delete a worksheet

Method 1 –
1. Select any worksheet
2. Right click on any worksheet and click ‘Delete’
Method 2 –
1. Select any worksheet
2. Click on ‘Delete Sheet’ option of ‘Delete’ button

Click to Enlarge

Once you have deleted the sheet the excel will look like

Query/Feedback