Microsoft Excel 
ITTraining@sgul.ac.uk Page 6 St. George’s Information Services 
INSERTING AND DELETING WORKSHEETS 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Once you’ve decided on a structure for your 
workbook, you may find that there are some 
worksheets that can be deleted. Alternatively, 
you may find that you need additional blank 
worksheets inserted. However, remember that 
deletion of worksheets is permanent and can’t be 
undone using Undo, so always save your 
workbook before making these changes. 
Try This Yourself: 
Open 
File Before starting this exercise 
you MUST open the file 
E1324 Worksheet 
Techniques_1.xlsx… 
 
Examine the workbook – it 
currently contains one 
worksheet named Sheet1 
 
Click on the New Sheet icon 
at the end of the worksheet 
tabs 
A new worksheet named 
Sheet2 will be inserted. You 
can also use the keyboard 
shortcut... 
 
Press  +  to insert 
another new worksheet 
This sheet is named Sheet3 
and is inserted before the 
currently selected sheet. 
Now let’s delete a sheet... 
 
Right-click on the Sheet3 
worksheet tab to display the 
shortcut menu 
 
Select Delete to remove the 
worksheet 
As the worksheet contains no 
data, the sheet will be 
deleted immediately. If a 
worksheet contains data, 
Excel will ask you to confirm 
your actions... 
 
Repeat steps 4 and 5 to 
delete Sheet2 
 
1 
2 
3 
4 
For Your Reference… 
To insert a new worksheet into a workbook: 
 Click on the New Sheet icon to the right of 
the worksheet tabs 
To delete a worksheet from a workbook: 
 Right click on the worksheet tab, then select 
Delete 
Handy to Know… 
 To insert a worksheet between existing 
worksheets, right-click on the worksheet tab 
before which you want to insert a new sheet, 
then click on Insert to display the Insert 
dialog box. Select Worksheet and click on 
[OK]. 
5