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...
I eventually figured it out by using a few extra steps:
- I added another column and numbered the rows.
- I sorted by each of the other columns to make the empty rows stand out.
- I removed the empty rows.
- I sorted again by the numbered column to restore the original order.
I only have a few columns, and most of the empty rows line up consistently, so this turned out to be the fastest method for me—especially since the other approach didn’t work.