| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
HELP ASAP get rid of blank rows without sort
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? -- ALFR |
|
#2
|
|||
|
|||
|
duplicate posting
"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? -- ALFR |
|
#3
|
|||
|
|||
|
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? 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort 2 or more rows of cells linked to one row of data | Excel Worksheet Functions | |||
| How do I move up rows below blank rows in an address? | Excel Worksheet Functions | |||
| Select rows, then sort | Excel Discussion (Misc queries) | |||
| How do I sort rows with hyperlinks? | Excel Discussion (Misc queries) | |||
| how do I print grid lines for blank rows | Excel Discussion (Misc queries) | |||
Linear Mode
