Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofilter not capturing all cells
Hi All,
I have a small issue that is getting to me a little on Excel 2003 SP3. I have a workbook that contains a lot of text on numerous rows (Basically the text of announcements we use in our telephony department.) When i use the autofilter function, many of the text boxes do not show up in the filter. It isn't a number of lines issue as the workbook oly contains 200 lines or so. I have noticed that if i set the cell formatting to text, the cell just shows ####################### If i right click on one of the cells in the column, and then select "pick from drop down list" the text is visible in that drop down list. It just isn't available in the autofilter drop down. Ironically, if i select "custom" from the autofilter drop down, and type contains xxxxxx (xxxxx being a word of phrase from one of the cells that doesn't show up" then the cell is filter correctly. Could anyone possibly explain and if so provide me with a workaround? Thanks Kevin |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofilter not capturing all cells
############## means that cell is formatted as a number or general...
and the value is larger than the cell width. Increase the column width and test... What is the number you see if you edit that cell? That should be available in the drop down... "panther42" wrote: Hi All, I have a small issue that is getting to me a little on Excel 2003 SP3. I have a workbook that contains a lot of text on numerous rows (Basically the text of announcements we use in our telephony department.) When i use the autofilter function, many of the text boxes do not show up in the filter. It isn't a number of lines issue as the workbook oly contains 200 lines or so. I have noticed that if i set the cell formatting to text, the cell just shows ####################### If i right click on one of the cells in the column, and then select "pick from drop down list" the text is visible in that drop down list. It just isn't available in the autofilter drop down. Ironically, if i select "custom" from the autofilter drop down, and type contains xxxxxx (xxxxx being a word of phrase from one of the cells that doesn't show up" then the cell is filter correctly. Could anyone possibly explain and if so provide me with a workaround? Thanks Kevin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
capturing all of the data | Excel Worksheet Functions | |||
Select cells after Autofilter | Excel Worksheet Functions | |||
Capturing Rows of Data | Excel Discussion (Misc queries) | |||
Capturing Date | New Users to Excel | |||
Capturing Equations From Charts | Charts and Charting in Excel |