| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
A number of auto filters in one sheet? Is it possible?
Hello! I would like to know- is it possible and how to use Auto filter in
Excel to more than one table in Office 2003? For example, if I want to use Auto filters for 3-4 tables together in one sheet? Thanks. Janis. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
A number of auto filters in one sheet? Is it possible?
Not possible
-- Regards, Peo Sjoblom "Janis" wrote in message ... Hello! I would like to know- is it possible and how to use Auto filter in Excel to more than one table in Office 2003? For example, if I want to use Auto filters for 3-4 tables together in one sheet? Thanks. Janis. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
A number of auto filters in one sheet? Is it possible?
You get one autofilter range per worksheet. You can remove it and reapply it to
a different range. But since you're using xl2003, you may want to look at Data|List. You can have multiple lists per worksheet and that may be sufficient for what you need. Janis wrote: Hello! I would like to know- is it possible and how to use Auto filter in Excel to more than one table in Office 2003? For example, if I want to use Auto filters for 3-4 tables together in one sheet? Thanks. Janis. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto filters and worksheet protection | Excel Worksheet Functions | |||
| List with auto filters | Excel Worksheet Functions | |||
| How can I auto-refresh auto-filters when data changes? | Excel Worksheet Functions | |||
| auto filters | Excel Discussion (Misc queries) | |||
| Auto update of filters | Excel Discussion (Misc queries) | |||
Linear Mode
