Delete worksheets in Excel 2007

Worksheets that you no longer need can be deleted. You can delete a single worksheet or you can delete multiple worksheets at the same time. To delete multiple worksheets, you have to select the worksheets first. Do the following to select multiple worksheets:
Selecting adjacent worksheets: Click on a sheet tab and then press the Shift key. Keep the Shift key in pressed state, click to select the last worksheet.
Selecting non-adjacent worksheets: Click on a sheet tab and then press the Ctrl key. Keep the Ctrl key in pressed state, click to select other worksheets.

Note:
You cannot select all the worksheets to delete. You will receive the message saying A workbook must contain at least one visible worksheet

Once the selection of the worksheet(s) is over, in the Home tab, in the Cells group, click Delete and click Delete Sheet.

You will be presented with a message box saying that Data may exist in the sheet(s) selection for deletion. To permanently delete the data, press Delete., click Delete.

If your worksheet does not contain data then the above message box will not appear.

You can also right-click the sheet tab of a worksheet or any of the selected worksheets sheet tab and click Delete to delete the worksheet(s).