Re: Difference between list and autofilter
From: JE McGimpsey (jemcgimpsey_at_mvps.org)
Date: 03/25/04
- Next message: Dave Peterson: "Re: Printing a worksheet with ActiveX controls messes up the controls"
- Previous message: znrd40: "Difference between list and autofilter"
- In reply to: znrd40: "Difference between list and autofilter"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 25 Mar 2004 16:10:39 -0700
I haven't worked with the List manager in XL03, but in MacXL01 and v.X,
the List Manager, in addition to applying an autofilter, can
-automatically apply validation to fields (columns)
-automatically and dynamically apply autoformats
-automaticaly and dynamically add formulas in calculated columns
-maintain and update totals
-automatically update pivot tables based on the list
-automatically update charts based on the list
-restrict entries to unique values
-maintain column headings so they don't get sorted or filtered
-maintain a totals row that can have just about any function (e.g.,
average, sumif, etc.
In article <znrd40.13p3xf@excelforum-nospam.com>,
znrd40 <<znrd40.13p3xf@excelforum-nospam.com>> wrote:
> Can anyone tell me the difference between the autofilter option in older
> versions of excel and the "list" option in Data in the 3002 version?
>
> I am trying to create a dropdown menu for lists and people with older
> versions of excel can't seem to use the custom "list" feature I have
> put in. Though they don't have "list" seems to mean it is the same
> thing as an autofilter, just more automated to set up. Am I missing
> something?
- Next message: Dave Peterson: "Re: Printing a worksheet with ActiveX controls messes up the controls"
- Previous message: znrd40: "Difference between list and autofilter"
- In reply to: znrd40: "Difference between list and autofilter"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
