| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofilter Hides All...
I have a column that contains number/letter format 100ABC, 101DEF, etc. When
I do a custom filter to show all the cells that contain 100, etc., the entire column hides. How do I get it to show the cells I want to see? Thanks....TomCat |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autofilter Hides All...
It worked fine for me in my tests (using xl2003).
Maybe the values in the cell aren't really what you see? Any chance that the cells have a custom format that changes the look, but not the value? What do you see in the formula bar when you have one of those cells selected? TomCat wrote: I have a column that contains number/letter format 100ABC, 101DEF, etc. When I do a custom filter to show all the cells that contain 100, etc., the entire column hides. How do I get it to show the cells I want to see? Thanks....TomCat -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Command button unhides but not hides | Excel Discussion (Misc queries) | |||
| code to hide hides too much | Excel Discussion (Misc queries) | |||
| When i hide columns it hides whole sheet | Excel Discussion (Misc queries) | |||
| Open workbook hides | Excel Discussion (Misc queries) | |||
| Button hides unhides columns, how? | Excel Discussion (Misc queries) | |||
Linear Mode
