How to Add or Delete a Worksheet in Excel 2003

You can save multiple worksheets within a single workbook in Excel 2003, so you may sometimes need to delete some worksheets and add others. Here is how to add or delete a worksheet in Excel 2003.

Difficulty: Moderately Easy

Instructions

Things You'll Need:

• Computer
• Excel 2003

1. Open Microsoft Excel on your computer. Find the file that you want to change by clicking “File” on the toolbar, selecting “Open” and browsing for the correct file name.

2. Go to the toolbar and click on “Insert” and then "Worksheet" if you would like to add a worksheet.

3. Flip between worksheets by clicking on the corresponding numbered sheet at the bottom of your screen.

4. Rename the worksheet. To organize your worksheets, you can add descriptive names to each one. Just left-click on the tab of the sheet that you want to change to reveal a drop-down menu. Click “Rename” on the menu and a cursor will appear where you can type the new name.

5. Delete a worksheet. If you no longer need a worksheet in your workbook, you can delete it. Just left-click on the numbered tab to reveal a drop-down menu. Click "Delete" on this menu. A pop-up will appear asking if you want to delete the file. If you are sure, click “OK” and the worksheet will be gone. If you are not sure, click “Cancel.”

6. Save your work after making changes.

Tips & Warnings

• You can switch between worksheets by clicking on the tab with the sheet’s name on it.
• You cannot use any special characters when renaming the worksheet.
• Once you delete a sheet, it is gone. You cannot use the "Undo" function to reverse a sheet deletion. The only way you can get it back is by immediately closing out of the program without saving your changes and then re-opening the workbook. Doing so will restore the last saved version. However, you will lose any other changes that you made since the last time you saved the file.