Though having blank rows ... bar in Excel, and click "Find & Select" on the right side. 2. Select "Go to Special." 4. Excel will then highlight all of the blank cells. Before you delete the ...