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 ass...
All of the suggestions here seem complicated or confusing to me. Or needed a special hidden formula on a file to some how use on an existing file. There was a simple solution that no one suggested. Select the row you want to be the last row, Press simultaneously -Ctrl, Shift, down arrow. It highlights everything from that selected rown and below. Then just right click and delete. So simple.