Working with Multiple Worksheets

When working in Excel XP group worksheets and freeze certain cells to more effectively navigate worksheets.

Deleting worksheets

Any worksheet can be deleted from a workbook, including those that have data in it. Remember, a workbook must contain at least one worksheet.

To delete one or more worksheets:

  • Click the sheet(s) you want to delete.
  • Choose EditDelete Sheet from the menu bar.

    Edit and Delete Sheet Menu Selections
  • The following dialog box appears if the sheet being deleted has information in it.

    Confirm Deletion Dialog Box
  • Click the Delete button to remove the worksheet and all data in it.

Another way to delete or insert a worksheet is to right-click the sheet to be deleted, then select Delete or Insert from the shortcut menu.

Shortcut Menu for Sheet Operations