| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I filter just one cell instead of the whole row?
That's it. Can I do this somehow?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to link Auto Filter values to a Cell | Excel Worksheet Functions | |||
| resetting last cell | Excel Discussion (Misc queries) | |||
| excel should allow me to filter rows on basis of the cell color | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Linear Mode
