| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Filter
When I use Auto Filter and select the criteria I want to filter by and then
go back to select all criteria certain rows are hidden, it does show all rows. Anyone know why? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Filter
Did you mean "it does NOT show all rows"?
If yes, then I'm guessing that you have more than one field/column filtered. In xl2003 menus, I'd use: Data|Filter|show all On the xl2007 ribbon, I think it's: Data tab|Sort & Filter group|Clear GV wrote: When I use Auto Filter and select the criteria I want to filter by and then go back to select all criteria certain rows are hidden, it does show all rows. Anyone know why? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Filter
That is what I meant and I tried what you suggested and it corrected my
issue. Thank you! "Dave Peterson" wrote: Did you mean "it does NOT show all rows"? If yes, then I'm guessing that you have more than one field/column filtered. In xl2003 menus, I'd use: Data|Filter|show all On the xl2007 ribbon, I think it's: Data tab|Sort & Filter group|Clear GV wrote: When I use Auto Filter and select the criteria I want to filter by and then go back to select all criteria certain rows are hidden, it does show all rows. Anyone know why? -- Dave Peterson . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Filter
ps.
You can add the icon for "show all" to your favorite toolbar (xl2003) or the QAT (xl2007)--well, I think in xl2007, too. In xl2003 menus: tools|customize|Commands tab|Data Category Drag the "Show All" icon to your favorite toolbar. You may want the the autofilter icon (looks like a funnel), too. I use that show all icon a lot! GV wrote: That is what I meant and I tried what you suggested and it corrected my issue. Thank you! "Dave Peterson" wrote: Did you mean "it does NOT show all rows"? If yes, then I'm guessing that you have more than one field/column filtered. In xl2003 menus, I'd use: Data|Filter|show all On the xl2007 ribbon, I think it's: Data tab|Sort & Filter group|Clear GV wrote: When I use Auto Filter and select the criteria I want to filter by and then go back to select all criteria certain rows are hidden, it does show all rows. Anyone know why? -- Dave Peterson . -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel auto-filter does not filter certain columns | Excel Discussion (Misc queries) | |||
| DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
| Excel 2007 Auto Filter Filter | Excel Discussion (Misc queries) | |||
| Limit filter options in Auto Filter | Excel Discussion (Misc queries) | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
Linear Mode
