Click on the arrow in the first column A. Select cells starting from the row containing blank cells.ĥ. Method 2: Using filters To Remove Empty Excel Rowsģ. Go to Home > Delete > Delete Sheet Rows.Ĩ. Blank rows in the worksheet have been selected.ħ. The Go To Special dialogue box will open.Ħ. Go to Home > Find & Select > Go To Special.Ĥ. How to Delete Blank Rows in Excel: Step-by-Step Method 1: Using blanks feature to Remove Blank Excel Rowsģ. Luckily, there is an alternative solution to this: learning how to remove blank rows in excel – without losing any data. Simply deleting cells won’t get the job done. You might have them due to some miscalculations in executing Excel’s automatic shortcuts. But in most cases, they are extravagant and unwanted. Sometimes, they are an essential part of the formatting process.
Blank spaces can give your Excel data worksheet a somewhat unprofessional look.