View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomCat TomCat is offline
external usenet poster
 
Posts: 34
Default 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