Technical Support

Remove empty rows on the worksheet

Spreadsheet Tools welcomes your inquiries. You can contact us by e-mail support@SpreadsheetTools.com, or fill the Technical Request form on the Spreadsheet Tools website.

We suggest you to review the topics below. Possible you'll find answer to your questions about xlCompare here.

We've created a F.A.Q section on our website. It contains answers to the most common questions we receive. In this section you'll also find a useful information for you. Go to the F.A.Q. topic

How to remove empty rows on the Excel worksheet xlCompare

One of the common tasks: you need to organize data on the worksheet you have: remove empty blocks, sort items, ... xlCompare allows you to automate some of them.

Right click menu on the every worksheet contains Delete Empty Rows command:

Remove empty rows command

It analyzes data on the worksheet and removes empty rows.

If you apply this command you may see that some rows are not deleted. Why? xlCompare tries to find "header" in your table and leave it. If header in your table has empty rows, xlCompare doesn't remove them to preserve formatting. In case if you want to clear header area also, you can remove them manually.

See Also: