How do I delete empty rows in excel but not empty cells in rows with information in them?
If you only want to delete rows that are completely empty, the easiest way I've found is to use a filter.  Highlight all of the columns that you want to include and then click the filter button.  Uncheck "select all", and then scroll to the very bottom and click to check the box for blanks.  This will show only your blank rows.  Highlight all and right-click a row and select delete.  This deleted all your blank rows.  Now turn off the filter and viola, no blank rows!