Forum Discussion
LisaR1959
Mar 19, 2021Copper Contributor
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...
Sandras1
Dec 07, 2024Copper Contributor
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
Stéphane
Feb 24, 2025Copper Contributor
Thanks a lot, a true time-saver !
Many thanks again.