Results 1 to 4 of 4

Thread: dropdown lists in headings by using Filter

  1. #1
    Junior Member
    Join Date
    Jan 2013
    Posts
    2
    Rep Power
    0

    dropdown lists in headings by using Filter

    Hi All

    Please see attached file

    1. How do i add a Filter to each heading?

    2. If i add further information in each column will the Filter add these new entries to the existing entries

    filter.xls?

    Any help appreciated

    Thanks

    Dane

  2. #2
    Member Ryan_Bernal's Avatar
    Join Date
    Dec 2012
    Posts
    37
    Rep Power
    0
    Highlight the headings you want to add filter then press ALT+D+F+F

  3. #3
    Junior Member
    Join Date
    Jan 2013
    Posts
    2
    Rep Power
    0
    Thanks Ryan

    Now if i add further entries into each column will it update the filter with these new entries?

    Thanks again

  4. #4
    Member Ryan_Bernal's Avatar
    Join Date
    Dec 2012
    Posts
    37
    Rep Power
    0
    Quote Originally Posted by Dane View Post
    Thanks Ryan

    Now if i add further entries into each column will it update the filter with these new entries?

    Thanks again
    Yes. 100%.
    Just give me your feedback if i've helped you!

Similar Threads

  1. How To Create DropDown ListBox In Excel
    By lokvan in forum Excel Help
    Replies: 3
    Last Post: 12-23-2014, 04:43 PM
  2. Filter In Arrays
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 05-28-2013, 08:40 PM
  3. Replies: 7
    Last Post: 04-22-2013, 01:41 PM
  4. Auto filter and sum up data
    By Ryan_Bernal in forum Excel Help
    Replies: 6
    Last Post: 01-02-2013, 06:42 PM
  5. Filter more than one pivot table at one time
    By larryt1940 in forum Excel Help
    Replies: 8
    Last Post: 05-04-2012, 06:45 PM

Posting Permissions

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