Excel - Select all empty rows/cells

April 2018

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.
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 (https://ccm.net/).
VBA - Conditional formatting- Apply color to last column
Excel - Entering fractions