Excel - Select all empty rows/cells

October 2016

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.

Related :

This document entitled « Excel - Select all empty rows/cells » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.