I don't have access to XP at the moment but I think it is a "feature".
As a workaround, select the rows and Data/Sort. That will eliminate the blanks (well, move the blank rows to the bottom).
OnePlus 5T review: Hands-on
Illustrator Andrés Lozano on his improv line work, brazen use of colours & hand sketching
iPhone X review
Comment envoyer gratuitement des gros fichiers ?