If Excel freezes when deleting rows or columns, identify the possible causes and then resolve the issue. Turn off Auto Save, disable COM Add-ins, etc.
You can remove blank rows in Excel by first doing a "Find & Select" of blank rows in the document. You can then delete them all at once using the "Delete" button on the Home tab. Once rows or cells ...