How to Add or Delete an Excel Worksheet

You can add as many worksheets as you like to a workbook. Be sure to delete worksheets that you're no longer using, though, to remove clutter from your file and avoid confusion. These steps work with Microsoft Excel 97.

Difficulty: Easy

Instructions

Things You'll Need:

• Excel Book
• Microsoft Excel

1. Open Microsoft Excel and open the file you want to change.

2. To add a worksheet, open the Insert menu and select Worksheet. The new sheet will appear before the selected sheet in the tab menu at the bottom of the Excel window. It will be numbered.

3. To delete a worksheet, first select the sheet by clicking its tab at the bottom of the Excel window, then open the Edit menu and select Delete Sheet. Click OK to delete the worksheet.

Tips & Warnings

• To give your new worksheet a specific name, see "How to Rename an Excel Worksheet," under Related eHows.
• You cannot restore a deleted worksheet by using Undo.