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.
Published by jak58
Latest update on December 12, 2012 at 09:57 AM by jak58.