Delete Empty Rows from Sheet

Follow these steps to delete all empty sheets from an Excel workbook:

1. Select the special process "[118] (*.XLS) Delete Empty Rows from Sheet" from the Special Process drop down list.

2. Next select the input and output files. If the input and output files specified are different, a new output workbook will be created, otherwise the input file will be modified.

3. Click the Click Here for 'Delete Empty Rows from Sheet' button.

 Specify the sheet to change.

    Sheets can specified by name or number.  

              You may specify ranges by index:  i.e. "2-4,10" or "*" for all.

              You may specify by name: i.e. "Sheet4","Sheet6","Accounting"

Specify rows to check for emptiness 

NOTE: Leave the Specify rows to check for emptiness blank to check the whole sheet for empty rows. You can specify specific rows like:

          2-4

Or even specify several sets of rows to check:

          100-200,50-70,1-2

IMPORTANT: If you are specifying more than one set of rows always do so in descending order, as shown immediately above. Separate each set with a comma

4. Optional: Click the Add (or ALT+A) button to add the task to the Conversion Task list. You may add multiple tasks to the Conversion Task list before initiating the conversion process by repeating Steps 1 - 3 as necessary.

5.  Click the Convert (or F5) button to execute the process.

Additional Details

This special process is used to clean up a workbook by removing any empty worksheets. The worksheet must be completely empty for it to be deleted. Whitespace characters such as space, tab etc that appear hidden in a sheet can keep it from being deleted.

Additionally, you can use this special process to delete empty sheets from a single workbook file, or a whole folder (and sub-folders) of workbooks. There must be at least one sheet in a workbook left. In other words, you cannot delete all the sheets in a workbook.

Note: If you name a sheet with only numbers, you will need to use quote marks around that name. For example, if you name a sheet 32, when you specify the Input Sheet you must input "32" with the quotes around the name so Convert XLS knows it is a name and not an index number for the sheet. If you browse for the file and click to select it, you will still need to manually add the quotes.