Autofilter Hides All...

  • Thread starter Thread starter TomCat
  • Start date Start date
T

TomCat

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
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AutoFilter: custom filter hides all 4
Autofilter not capturing all cells 2
Count the number of AutoFiltered records 6
Hide columns based on row values 2
Test for Number 3
Hide unused rows based on column info 5
Auto Filter 4
Filter by Top 10 doesn't work 1

Back
Top