Forum Discussion

LisaR1959's avatar
LisaR1959
Copper Contributor
Mar 19, 2021

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 ass...
excel
Sandras1's avatar
Sandras1
Copper Contributor
Dec 07, 2024

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

  • sbernard1550's avatar
    sbernard1550
    Copper Contributor
    Dec 09, 2024

    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  

Resources