Download Starting Excel 2007

Managing Workbooks
Inserting and Deleting
Worksheets
Exercise
• Exercise File: Sales6-5 xlsx
• Exercise: Insert a new worksheet, then delete it.
You can easily add worksheets to a workbook or delete
unwanted ones.
Insert a worksheet
1. Click the Insert Worksheet tab.
A new worksheet is added to the workbook.
Tip: The Insert Worksheet tab is located next to
the sheet tabs near the bottom of the workbook
window.
Other Ways to Insert a Worksheet:
Press <Shift> + <F11>. Or, click the Home tab
on the Ribbon and click the Insert list arrow in
the Cells group. Select Insert Sheet. Or, rightclick the tab of an existing worksheet, and select
Insert from the contextual menu. Select
Worksheet in the General tab of the Insert dialog
box and click OK.
Click here to insert
a new worksheet.
Figure 6-9: Inserting a worksheet.
Delete a worksheet
1. Right-click the sheet tab you want to delete and select
Delete from the contextual menu.
The worksheet is deleted.
Other Ways to Delete a Worksheet:
Select the worksheet you want to delete, click the
Home tab on the Ribbon, click the Delete list
arrow and select Delete Sheet.
Figure 6-10: Deleting a worksheet from a workbook.
DoubleTechs.com Remote Computer Repair
Page 94