Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Column Filter (Excel 2003)

    Hi all,

    Is there a way to have the columns filter like what Excel is currently have for filtering rows.

    regards, francis
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Column Filter (Excel 2003)

    There is no built-in support for that. You'd have to program it yourself. I'm afraid you won't find examples of that easily, if at all.

  3. #3
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Column Filter (Excel 2003)

    Recognizing that this will have a 256 row limitation, I suggest that the best approach would be:
    <UL><LI>Copy the range of interest;
    <LI>Create a new sheet or workbook.
    <LI>In the new object, pulldown Edit>Paste Special
    <LI>Select: Values; None; and Transpose[/list]Now filtering on the rows will yield the same results (transposed), as would be achieved by filtering on columns in the original worksheet.

    H.T.H.
    Regards
    Don

  4. #4
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Column Filter (Excel 2003)

    Hi Don

    Thanks for the suggestion, a good work around.
    However, I am looking for an almost similar way like the filter built-in function that Excel offer, something like " horizontal filter ".

    regards, francis
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Column Filter (Excel 2003)

    There is no such feature, I'm afraid.

  6. #6
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Column Filter (Excel 2003)

    Hi Hans

    Thanks. Its would be more efficient to have this feature as well. Not sure if 2007 version have something simliar to it given that the columns have
    expanded.

    regards, francis
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Column Filter (Excel 2003)

    I don't have Excel 2007, but as far as I know this feature hasn't been added. I don't think it will be added in a future version, but who knows...

  8. #8
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Column Filter (Excel 2003)

    One has to ask why it is necessary to have the table oriented in a manner that requires column filtering.
    Regards
    Don

Posting Permissions

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