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

That's it. Can I do this somehow?

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

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.

"Some Dude" wrote:

That's it. Can I do this somehow?

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

A better way? What's wrong with this? It works great. Thanks

"tim m" wrote in message
...
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.

"Some Dude" wrote:

That's it. Can I do this somehow?

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

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

Then apply data|filter|autofilter.

Some Dude wrote:

That's it. Can I do this somehow?

--

Dave Peterson

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

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

On Thu, 27 Jul 2006 11:59:12 -0500, Dave Peterson
wrote:

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

Then apply data|filter|autofilter.

Some Dude wrote:

That's it. Can I do this somehow?

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

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 wrote:

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

On Thu, 27 Jul 2006 11:59:12 -0500, Dave Peterson
wrote:

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

Then apply data|filter|autofilter.

Some Dude wrote:

That's it. Can I do this somehow?

--

Dave Peterson

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

Duhhh<g



On Thu, 27 Jul 2006 13:12:34 -0500, Dave Peterson
wrote:

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 wrote:

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

On Thu, 27 Jul 2006 11:59:12 -0500, Dave Peterson
wrote:

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

Then apply data|filter|autofilter.

Some Dude wrote:

That's it. Can I do this somehow?

Gord Dibben MS Excel MVP