View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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