• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Delete Sheets in Excel

October 25, 2021 by Andrew Childress
Delete sheet right click

When you're ready to adjust what's in your Excel workbook, it helps to delete sheets in Excel. Here's how to do that with the help of this tutorial.

Don’ t think of Excel workbooks as files that remain the same. As your data and analysis needs grow, you’ll need to add, remove, and adjust how your sheets fit together.

When you’re ready to adjust what’s in your Excel workbook, it helps to delete sheets in Excel. Let’s learn how to do that efficiently with the help of this tutorial.

Delete a Sheet in Excel

To delete a sheet in Excel, just right-click on the sheet name. Then, choose Delete. That’s really all there is to it. You’ll see the sheet disappear and the tab bar will adapt.

Delete sheet right click

Here’s an important note: before you delete a sheet, be certain that you don’t need it. That includes formulas on other sheets that might rely on the data you deleted. That will break your formulas.  Deleting sheets in Excel is one step that can’t be undone with the “Undo” button. It’s lost for good once you delete it.

Delete Sheets in Excel

There’s no need to go one-by-one if you know you need to remove multiple sheets. On Windows, hold Control on your keyboard, then click on all of the sheet tabs you wish to delete. You can take the same steps on macOS by holding Command and selecting several sheets.

Delete multiple sheets

Then, follow the same steps to delete the selected sheets: right-click and choose Delete to delete all selected sheets. Excel will ask you to confirm that you wish to delete the sheets, and then the task is complete.

One last thing: you can hold shift on your keyboard and select a sheet tab in the workbook. This selects every sheet in the adjacent sequence of tabs. Then, just repeat the right-click delete sequence to remove all selected sheets.

Select multiple sheets

Remember both of these shortcuts while you manage your workbook. It’s all about saving time while adapting to your changing needs.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Hyperlink Menu excelClear Hyperlinks in Excel
Next Post:Delete Sheet Rows in ExcelDelete sheet rows in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top