Remove Blank Rows and Columns in Excel in a Few Clicks
Tables can get confusing. Clearing a sheet with empty rows or columns sounds simple enough, but it can be time consuming if you do it manually. This method allows you to get the job done in just a few clicks, even with huge spreadsheets.
First, highlight the area of your spreadsheet where the blank lines are. Include the line just above the first blank line and the line just below the last blank line in your selection.
If you are using Excel 2013, go to the Home tab, then to the Editing section and click Find and Select. Click “Go to Special …” in the drop-down menu and select “Spaces.” Click OK. Now only empty cells should be selected. Click the Home tab again, go to the Cells section and click Delete Sheet Rows from the drop-down menu. You can repeat a similar process to remove empty columns from your spreadsheet.
Even if you’re not using Excel 2013, a quick Google search for “Find and Select” in your version of Excel will reveal a keyboard shortcut that does the same for you. For example, in Mac Office 2011, the keyboard shortcut is Ctrl + G.
How to Remove Blank Rows and Columns Quickly and Easily in Excel 2013 | How-To Geek