Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I sort out data?
I have done an auto filter. Then, I cannot find some information in the drop
down box, although it is there. The info. has been sorted out AtoZ. But the box only shows the information starting with A and B. However, I have input many words starting with other letters. And some of the words have disappeared. How can I fix that, please?. Thanks a lot. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I sort out data?
And you're sure you applied the data|Filter|autofilter to all the rows in your
range? If you're sure, then maybe this is the problem: http://contextures.com/xlautofilter02.html#Limits (from Debra Dalgleish's site) She includes some work-arounds, too. carmen wrote: I have done an auto filter. Then, I cannot find some information in the drop down box, although it is there. The info. has been sorted out AtoZ. But the box only shows the information starting with A and B. However, I have input many words starting with other letters. And some of the words have disappeared. How can I fix that, please?. Thanks a lot. -- Dave Peterson |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I sort out data?
Thank you very much for your help, Dave. "Dave Peterson" wrote: And you're sure you applied the data|Filter|autofilter to all the rows in your range? If you're sure, then maybe this is the problem: http://contextures.com/xlautofilter02.html#Limits (from Debra Dalgleish's site) She includes some work-arounds, too. carmen wrote: I have done an auto filter. Then, I cannot find some information in the drop down box, although it is there. The info. has been sorted out AtoZ. But the box only shows the information starting with A and B. However, I have input many words starting with other letters. And some of the words have disappeared. How can I fix that, please?. Thanks a lot. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOw do i find and sort out data repeats for specific data set | Excel Discussion (Misc queries) | |||
Help to sort out filtered data from the data contained in another sheet of the same workbook | Excel Worksheet Functions | |||
I want to convert word column data to excel row data to sort addre | Excel Discussion (Misc queries) | |||
data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) |