DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

How to Delete All Blank or Empty Worksheets in Excel Office 365?

In this tutorial, we will guide you to know the steps Delete All Blank or Empty Worksheets in Excel Office 365 using Kutools. Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Note:

  • kutools for Excel has more than 180 features which are used to complete the difficult task with several clicks.
  • If you want to use Kutools, you need to install it from Excel’s official website.
  • You can reuse anything with the help of Kutools. The most used formulas, charts, or anything else you reuse in the future. ## Remove Blank Worksheets:

To remove all blank worksheets from dozens of sheets in Excel, follow the below instructions.

  • Let’s consider an example workbook that contains 10 worksheets. Out of ten, four worksheets are blank , and they are located in a different position.
  • Refer to the below screenshot.

Example worksheets
Example worksheets

  • Then, Go to the Kutools Plus Tab, select the Worksheet option, choose the Delete Blank Worksheets option from the drop-down list.

"Select

  • It will display the Kutools for Excel Dialog box to ask for your confirmation for deleting all blank sheets.
  • After that, you need to click the Yes button.

Kutools for Excel Dialog Box
Kutools for Excel Dialog Box

  • Now, it will open another prompt box to tell you how many blank worksheets deleted successfully.
  • Hit the OK button to get the result.

Prompt box
Prompt box

  • At last, the blank worksheets have been deleted from your workbook as shown in the below image.

Output
Output

Wrap-Up:

In this tutorial, we guided you to know the steps Delete All Blank or Empty Worksheets in Excel Office 365 using Kutools. ** Share your **suggestions/feedback in the comment box. Thanks for visiting Geek Excel. Keep Learning!

Keep Reading:

Top comments (0)