Excel - Select all empty rows/cells

March 2017


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


Published by jak58.
This document, titled "Excel - Select all empty rows/cells," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).