Inside The Web
    Facebook Twitter Instagram
    Inside The Web
    • Office
      • Excel
      • Ms Word
      • Gmail
      • Powerpoint
    • Productivity
      • Time Management
      • Task Automation
    Inside The Web
    Home»Excel»How to Delete Worksheet in Excel
    how to delete worksheet in excel

    How to Delete Worksheet in Excel

    0
    By nikhil on December 28, 2022 Excel

    If you’ve been using Excel for a while, you may have come across old or redundant worksheets in your workbook. These worksheets can cause errors, take up storage space and make your workbook look cluttered.

    Deleting unwanted worksheets can make your workbook look professional and organized. If you’re looking for ways to delete worksheets in Excel, we have listed five easy-to-follow methods to do so.

    Note: You cannot delete worksheets that are shared or protected. Also, you cannot delete all the worksheets from your workbook at the same time.

    Through Keyboard Shortcut

    Excel offers plenty of keyboard shortcuts for its features. You can use these shortcuts to delete Excel Worksheets. Press the Alt key to highlight the shortcut keys.

    1. Launch Excel and open the workbook.
    2. Switch to the worksheet you wish to delete.
    3. Press the Alt then the H, D, S keys in succession.
      delete-sheet-keyboard-shortcut
    4. Alternatively, you can also press the Alt, E, L keys in succession to delete the worksheet.
    5. Select Delete to confirm the given prompt.
      delete-prompt

    Through Worksheet Tab

    In Excel, all your Worksheets are stacked next to one another in the Worksheet tab. You can delete the worksheet from the tab. 

    1. Open the Excel Workbook.
    2. Right-click on the Worksheet you wish to delete. You can select multiple worksheets by clicking the sheets while holding the Ctrl button.
    3. Select the Delete option.
      delete-from-worksheet
    4. Click on Delete on the given prompt.

    Through Ribbon Panel

    The Ribbon Panel provides additional features over the menu bar which include deleting Cells, Sheet rows, columns, and the Worksheet itself.

    1. Launch Excel.
    2. Select the Worksheet that you wish to remove. Select multiple sheets by holding down the Ctrl key.
    3. Switch to the Home tab.
      switch-to-home
    4. Click on Delete under the Cells section.
    5. Select Delete Sheet.
      Delete-from-ribbon
    6. Click on Delete.

    Through Navigation Pane

    The Navigation Pane, a feature introduced in Office 365 is used for navigating through the workbook. Besides browsing, you can also delete the worksheets via the Navigation Pane.

    1. Open Excel.
    2. Switch to the View tab and select Navigation.
      navigation
    3. Right-click the sheet that you wish to delete under the Pane.
    4. Select Delete.
      excel-delete
    5. Click Delete on the given prompt.
      excel-delete

    Through VBA

    Visual Basic for Application(VBA) is a programming tool that gives additional functionality to Office applications. You can use this tool to delete worksheets in Excel.

    Here’re the steps for deleting a single worksheet:

    1. Open the Workbook in Excel.
    2. Switch to the worksheet you wish to delete.
    3. Right-click on the sheet and select View Code.
      view-code
    4. Type the following code in the given prompt
      Sub DeleteSheet()
      ActiveSheet.Delete
      End Sub
      delete-code
    5. Press the F5 button on the keyboard to run the code.
    6. Click on Delete to confirm the prompt.

    Here’re the steps for deleting multiple worksheets:

    1. Right-click on a worksheet in Excel and select View Code.
    2. Type in the following code in the prompt.
      Sub DeleteWorkSheet()
      Sheets("WorkSheet1").Delete
      Sheets("WorkSheet2").Delete
      End Sub
      delete-multiple-code
    3. Press the F5 key to run the code.
    4. Select Delete on the prompt.
      delete-prompt
    excel
    Previous ArticleGoogle Review Not Showing Up? Here’s How to Fix It
    Next Article How to Unblock Someone on Facebook on Phone
    nikhil

      Add A Comment
      Recent Posts
      • How to Remove Dotted Lines in Excel
      • What Does “Too Many Different Cell Formats” Mean? How to Fix it
      • How to Delete Drop-down List on Excel
      • How to Set Print Area in Excel (4 Ways)
      • How to Track Changes in Excel
      • Home
      • Privacy Policy
      © 2023 Inside The Web

      Type above and press Enter to search. Press Esc to cancel.