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...
HansVogelaar
Mar 19, 2021MVP
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.