Shift-click to add an adjacent row or column to your selection. Click on the "Home" tab in the Microsoft Excel Ribbon.

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 ...