Forum Discussion
Delete Empty Rows Quick?
I have a worksheet with thousands of rows and a blank row between each row with data. Is there a way to remove all those blank rows quickly? I need to sort by a column and I can't right now. I assume that is because of the blank rows.
To quickly delete empty rows in Excel, select your data range (Ctrl + A), press F5 or Ctrl + G, click "Special," and choose "Blanks." This will highlight all empty cells. Right-click one of the highlighted cells, select "Delete," then choose "Entire Row" and click "OK" to remove all empty rows. And for activate Windows 11 pro , Microsoft partners like S2keys
To quickly delete empty rows in Excel, select your data range (Ctrl + A), press F5 or Ctrl + G, click "Special," and choose "Blanks." This will highlight all empty cells. Right-click one of the highlighted cells, select "Delete," then choose "Entire Row" and click "OK" to remove all empty rows. And for activate Windows 11 pro , Microsoft partners like S2keys
Hi Sandra, thanks for this. The problem i have is that in my data table, I also have a single cell that is blank on another row. So when I do 'go to special/blank/delete entire row', it removes the blank row that i want removed, but ALSO removes the row that has 1 blank cell. It removes that whole row as well, which is not what I want. Would you know why it does that ? Perhaps you can try yourself to see ? Thanks
LisaR1959
Old post I know but this answer may be useful to someone.
Easiest way:
Select all cells with data in them - exclude headers if you have them.
On the ribbon bar (Home tab), select Sort & Filter
Select Sort A to Z
Done! All the blank rows have been moved below the data.With that you loss initial rows order. If do such way it's more reliable to add helper column with sequential numbers from top to down, sort on any other columns, remove rows with blanks from down, sort again on helper column, remove helper column.
IMHO, on the range F5->Special->Blanks->Delete Sheet rows not very complex.
If without shortcuts - select any column within range, on ribbon Find&Select->Go to Special->Blanks->Ok
All blank cells will be selected. With that Cells->Delete->Delete Sheet Rows
Thankyou bro it works 😍
When i do what you suggested, it also deletes the columns. And at the end, there is nothing left on my sheet, at all.
I'm only trying to delete the blank rows.
Any idea what i'm doing wrong ?
Thx! Suzanne
Assume we have such range, select it, GoTo Special and select Blanks
Click Ok, right after that Delete -> Delete Sheet rows
Click on it, now rows are deleted
That's straightforward, the only is to select the range correctly at very beginning.
- Thank you. This tip helped me quickly clean up a sheet.
Select the entire sheet (or its used range), then use the Tab key to move to the column you want to sort on, if necessary. You should then be able to sort the sheet, causing the empty rows to move to the bottom.
