| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto filter
Does anybody know if it's possible to put 2 autofilters in one sheet?
At this moment I have them seperated in two sheets, but I have to switch the whole time. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
auto filter
In excel versions up to xl2002 (XP), I believe one autofilter per sheet was
the limit. Excel 2003 added a LIST construct/concept which includes an autofilter. I don't know if you can put more than one on a sheet or not. -- Regards, Tom Ogilvy "minostrada" wrote in message ... Does anybody know if it's possible to put 2 autofilters in one sheet? At this moment I have them seperated in two sheets, but I have to switch the whole time. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
auto filter
I just tried it and you can have multiple lists per worksheet in xl2003.
To the OP: You have another response to your post in .excel. Tom Ogilvy wrote: In excel versions up to xl2002 (XP), I believe one autofilter per sheet was the limit. Excel 2003 added a LIST construct/concept which includes an autofilter. I don't know if you can put more than one on a sheet or not. -- Regards, Tom Ogilvy "minostrada" wrote in message ... Does anybody know if it's possible to put 2 autofilters in one sheet? At this moment I have them seperated in two sheets, but I have to switch the whole time. -- 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
