Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
autofilter question
when using autofilter, i select a value i don't want, the autfilter gives me
all the rows i don't want to see. i hide them. how do i see just the rows i haven't hidden? don't necessarily need code, just how is this done? -- Gary K |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
autofilter question
Hi Gary..........
Autofilter is designed to DISPLAY the rows you WANT, not to get rid of the ones you don't., as such. Try using the CUSTOM selection in the dropdown box and choosing one of the "does not contain", or "begins with", etc selections to customize the filter for your needs........ hth Vaya con Dios, Chuck, CABGx3 "Gary Keramidas" wrote in message ... when using autofilter, i select a value i don't want, the autfilter gives me all the rows i don't want to see. i hide them. how do i see just the rows i haven't hidden? don't necessarily need code, just how is this done? -- Gary K |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
autofilter question
Try this, instead:
Click on the AutoFilter dropdown arrow Select: Custom On the fields Select: Does not equal Select the value you do NOT want displayed Click the [OK] button Does that help? *********** Regards, Ron XL2002, WinXP "Gary Keramidas" wrote: when using autofilter, i select a value i don't want, the autfilter gives me all the rows i don't want to see. i hide them. how do i see just the rows i haven't hidden? don't necessarily need code, just how is this done? -- Gary K |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoFilter Question | Excel Discussion (Misc queries) | |||
AutoFilter Question | Excel Discussion (Misc queries) | |||
Autofilter question | Excel Programming | |||
Autofilter Question | Excel Discussion (Misc queries) | |||
Autofilter Question | Excel Programming |