Delete All Blank Worksheets with One Click in Excel 2007/2010

Most Excel users may face a problem ahead that if you want to delete all the blank worksheets in a workbook with dozens of sheets, how should you do? You may need to select the blank sheets one by one, right-click the sheet tab and choose the “Delete” option in the menu. Being tired with this repetitive and time-consuming operation, Users can use the Kutools for Excel’s Delete Blank Worksheets tool, which helps quickly delete all the blank worksheets (including the hidden worksheets) with only one click in Microsoft Excel 2007/2010. Demo

Click "Kutools">>"Worksheets Tools">>"Delete Blank Worksheets". See screenshots (Fig.1 and Fig.2).

Fig.1 Delete Blank Worksheets		Fig.2 Delete Blank Worksheets

Let us look at the following example to quickly understand how fast and powerful this tool works. There is an active workbook contains 9 worksheets, and the sheet1, sheet2, sheet4 and sheet3 are blank worksheets staying in different positions of the sheet tab bar. (See Screenshot Fig. 3)

Fig.3 Before deleting blank worksheets

And then, use the Delete Blank Worksheets tool in Kutools for Excel, click “OK”, you will delete these 4 blank worksheets. (See Screenshot Fig. 4)

Fig. 4 After deleting blank worksheets

See Delete Blank Worksheets feature demo (video 1)

This is only one feature of Kutools for Excel

It includes more than 100 functions and tools for Excel 2007 and 2010.