This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2007 - Delete a Worksheet from a Workbook

Tired of seeing all of the tabs in the Sheet Tabs near the bottom of Microsoft Excel 2007? Does your current workbook not require so many sheets?

Here's how you can remove a worksheet from the current workbook.

Option 1:

1. Right-click a sheet tab you wish to remove.

2. Choose "Delete" from the pop-up menu that follows. Note that unless the selected sheet is empty you will have to confirm your decision.

Option 2:

1. Select the sheet in the Sheet Tab bar that you wish to remove.

2. Click the "Home" tab in the ribbon at the top of Excel 2007.

3. In the "Cells" group, click on the "Delete" pull-down and select "Delete Sheet". Again, note that unless the sheet is empty you will have to confirm your decision.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2007 - Delete a Worksheet from a Workbook.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.