Excel will then highlight all of the blank ... go to the Home tab and find the "Delete" button on the right-hand side. Select "Delete Sheet Rows." This will remove the blank rows.

(Screenshot: TechRepublic) SEE: Learn how to parse time values in Microsoft Excel. Choosing Delete Cells removes only the blank cells in the selected range. If you choose Delete Sheet Rows in step ...