+ Reply to Thread
Results 1 to 10 of 10

Excel Autofilter options (version)?

  1. #1
    HotRod
    Guest

    Excel Autofilter options (version)?

    I have MS Excel 2002 running in XP Pro. When I use the Data-Autofilter
    function, I get an alphabetical list of all names in the drop-down box. What
    I would like to have is the check boxes beside each name (drop down check
    list) so that I can select more than one name to filter by. Our IT
    department advises that this must be a optional function in Excel that needs
    to be enabled, but they did not know where this option is located. Any
    ideas? I know that this function was available when I trained in excel last
    year (version unknown)



  2. #2
    JulieD
    Guest

    Re: Excel Autofilter options (version)?

    Hi

    As far as i know, this option is only available when using pivot tables, not
    using data / autofilter .... could it be that you're thinking of from your
    training course.

    --
    Cheers
    JulieD
    check out www.hcts.net.au/tipsandtricks.htm
    ....well i'm working on it anyway
    "HotRod" <NOSPAM@youremail.com> wrote in message
    news:exC14wzSFHA.3464@tk2msftngp13.phx.gbl...
    >I have MS Excel 2002 running in XP Pro. When I use the Data-Autofilter
    >function, I get an alphabetical list of all names in the drop-down box.
    >What I would like to have is the check boxes beside each name (drop down
    >check list) so that I can select more than one name to filter by. Our IT
    >department advises that this must be a optional function in Excel that
    >needs to be enabled, but they did not know where this option is located.
    >Any ideas? I know that this function was available when I trained in excel
    >last year (version unknown)
    >
    >




  3. #3
    Ron de Bruin
    Guest

    Re: Excel Autofilter options (version)?

    My EasyFilter Add-in have 5 options
    Maybe you can use it
    http://www.rondebruin.nl/easyfilter.htm


    --
    Regards Ron de Bruin
    http://www.rondebruin.nl



    "HotRod" <NOSPAM@youremail.com> wrote in message news:exC14wzSFHA.3464@tk2msftngp13.phx.gbl...
    >I have MS Excel 2002 running in XP Pro. When I use the Data-Autofilter function, I get an alphabetical list of all names in the
    >drop-down box. What I would like to have is the check boxes beside each name (drop down check list) so that I can select more than
    >one name to filter by. Our IT department advises that this must be a optional function in Excel that needs to be enabled, but they
    >did not know where this option is located. Any ideas? I know that this function was available when I trained in excel last year
    >(version unknown)
    >
    >




  4. #4
    HotRod
    Guest

    Re: Excel Autofilter options (version)?

    I think either myself or the user was on crack when we saw this
    functionality. I have to go back to the college and double check this.



  5. #5
    HotRod
    Guest

    Re: Excel Autofilter options (version)?

    Called the college I.T. and they said that they are running Excel 2002 XP on
    all of the computers in that lab. Does that make a difference?



  6. #6
    Dave Peterson
    Guest

    Re: Excel Autofilter options (version)?

    Nope.

    My bet is it wasn't autofilter. I'm gonna guess it was a combobox from the
    control toolbox toolbar with its ListStyle set to "1 - fmListStyleOption"

    But that shows as a small circle.

    HotRod wrote:
    >
    > Called the college I.T. and they said that they are running Excel 2002 XP on
    > all of the computers in that lab. Does that make a difference?


    --

    Dave Peterson

  7. #7
    JulieD
    Guest

    Re: Excel Autofilter options (version)?

    nah, my vote's still on pivot tables HotRod, didn't you get a manual from
    the course - if so, check the contents ....

    --
    Cheers
    JulieD
    check out www.hcts.net.au/tipsandtricks.htm
    ....well i'm working on it anyway
    "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
    news:42702226.F65DEEF3@netscapeXSPAM.com...
    > Nope.
    >
    > My bet is it wasn't autofilter. I'm gonna guess it was a combobox from
    > the
    > control toolbox toolbar with its ListStyle set to "1 - fmListStyleOption"
    >
    > But that shows as a small circle.
    >
    > HotRod wrote:
    >>
    >> Called the college I.T. and they said that they are running Excel 2002 XP
    >> on
    >> all of the computers in that lab. Does that make a difference?

    >
    > --
    >
    > Dave Peterson




  8. #8
    HotRod
    Guest

    Re: Excel Autofilter options (version)?

    I'm going to go back and have another look, I'll post what I find out. It
    might be a dream...



  9. #9
    Tom Ogilvy
    Guest

    Re: Excel Autofilter options (version)?

    And that only allows a single selection.

    --
    Regards,
    Tom Ogilvy


    "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
    news:42702226.F65DEEF3@netscapeXSPAM.com...
    > Nope.
    >
    > My bet is it wasn't autofilter. I'm gonna guess it was a combobox from

    the
    > control toolbox toolbar with its ListStyle set to "1 - fmListStyleOption"
    >
    > But that shows as a small circle.
    >
    > HotRod wrote:
    > >
    > > Called the college I.T. and they said that they are running Excel 2002

    XP on
    > > all of the computers in that lab. Does that make a difference?

    >
    > --
    >
    > Dave Peterson




  10. #10
    Dave Peterson
    Guest

    Re: Excel Autofilter options (version)?

    I'm hedging my bet. I like yours better!

    JulieD wrote:
    >
    > nah, my vote's still on pivot tables HotRod, didn't you get a manual from
    > the course - if so, check the contents ....
    >
    > --
    > Cheers
    > JulieD
    > check out www.hcts.net.au/tipsandtricks.htm
    > ...well i'm working on it anyway
    > "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
    > news:42702226.F65DEEF3@netscapeXSPAM.com...
    > > Nope.
    > >
    > > My bet is it wasn't autofilter. I'm gonna guess it was a combobox from
    > > the
    > > control toolbox toolbar with its ListStyle set to "1 - fmListStyleOption"
    > >
    > > But that shows as a small circle.
    > >
    > > HotRod wrote:
    > >>
    > >> Called the college I.T. and they said that they are running Excel 2002 XP
    > >> on
    > >> all of the computers in that lab. Does that make a difference?

    > >
    > > --
    > >
    > > Dave Peterson


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1