Can I filter just one cell instead of the whole row?

T

tim m

There is probably a better way to do this I'm sure but if push comes to shove
you could insert a blank column before and after the column you want to
filter and then hide the blank columns then use the autofilter.
 
D

Dave Peterson

Just select the range to filter first. (Just the single column.)

Then apply data|filter|autofilter.
 
G

Gord Dibben

How does one filter just one cell?

What's to filter?

I was getting confused yesterday......this is worse<g>


Gord Dibben MS Excel MVP
 
D

Dave Peterson

I suspect that the OP wanted the arrow key to show up in one cell--filtering a
single column.

But I could be wrong...
 
G

Gord Dibben

Duhhh<g>



I suspect that the OP wanted the arrow key to show up in one cell--filtering a
single column.

But I could be wrong...

Gord Dibben MS Excel MVP
 
Top