Autofilter Hides All...

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
 
D

Dave Peterson

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
Print macro that hides rows before printing 1
Auto Filter 4
Merged cells disturb autofilter indicator 2
Hide Rows based on value, but not using autofilter 2
Count the number of AutoFiltered records 6
Filter by Top 10 doesn't work 1

Top