How to Add or Delete a Worksheet in Excel 2003

By eHow Computers Editor

Rate: (3 Ratings)

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.

Instructions

Difficulty: Moderately Easy

Things You’ll Need:

  • Computer
  • Excel 2003
Step1
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.
Step2
Go to the toolbar and click on “Insert” and then "Worksheet" if you would like to add a worksheet.
Step3
Flip between worksheets by clicking on the corresponding numbered sheet at the bottom of your screen.
Step4
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.
Step5
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.”
Step6
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.

Post a Comment

POST A COMMENT

Request a New How-To Article

Looking for more How To information? Chances are there’s an eHow member who knows how to do what you’re looking to do. Submit an article request now!

eHow Article: How to Add or Delete a Worksheet in Excel 2003

eHow Computers Editor

eHow Computers Editor

Category: Computers

Articles: See my other articles

Related Ads