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