| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Why does AutoFilter display rows NOT selected from drop down box?
In Win 2003 Excel with a list of columns, one column has numerous blank cells
and the adjacent column is blank (except for the header). With autofilter on, a value is selected from the drop down box. The first set of rows with the selected value displays, along with rows of other values not selected. The subsequent rows with the selected value are not moved to the top, but reside within the remaining rows. COLUMN Putting autofilter on this column and seleting for Bob: COLUMN Bob Eric Bob Bob Bob Steve Bob Steve Bob Tom Tom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change display font to actual selected font | Excel Discussion (Misc queries) | |||
| HOW DO I DISPLAY ZERO VALUES IN SELECTED CELLS IN EXCEL. | Excel Discussion (Misc queries) | |||
| Copying selected rows to another sheet | Excel Worksheet Functions | |||
| Compare and display multiple rows | Excel Worksheet Functions | |||
| How can I make autofilter show the filtered number of rows | Excel Worksheet Functions | |||
Threaded Mode
