HELP ASAP get rid of blank rows without sort

G

Guest

or maybe with sort I don't know. All data in Column A several rows between
data. When I sort, all numbers go to top and names and ids drop to bottom.
How to maintain data integrity in the group and still delete the rows?
 
H

Harlan Grove

Arlene wrote...
or maybe with sort I don't know. All data in Column A several rows between
data. When I sort, all numbers go to top and names and ids drop to bottom.
How to maintain data integrity in the group and still delete the rows?
Click to expand...

Simplest way is to select the entire range, run Data > Filter >
Autofilter, choose (Blank) in the drop-down list for any of the columns
which will filter out rows in which that column contains blanks, delete
the filtered rows, and run Data > Filter > Autofilter again to clear
the autofilter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to get rid of blank rows without sort 3
Please Help and Thank you! 1
Sorting by date and ASAP 3
Sorting rows 5
Sorting day names chronologically 5
Relate rows (child/ parent), secure relations for sorting 2
sort Excel 2007 to include empty row between data? 2
sorting in excel 2003 1

Top