If your Excel table contains empty rows/cells, here's a simple tip to select them:
- First select the concerned cells and press the F5 key.
- Click on the "Special" button
- In the "Go to Special" dialog, select "Blanks"
- Click on the OK button an all the empty rows/cells will be selected
- From there you can delete or edit them.