Working with Multiple Worksheets

When working in Excel 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 on the sheet(s) you want to delete.
  • Choose Edit Delete Sheet from the menu bar.

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

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

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

Shortcut Menu for Sheet Operations