Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Nov 2002
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Drop Down List (MS OFFICE PRO 2000)

    I need to create drop down lists for the new columns (like the ones arleady there, i.e. RANK) that have been added. I am not sure what they are called, and help didnt do much of that. Any suggestions? Attactched is a copy of the workbook I am using. Thanks

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

    Re: Drop Down List (MS OFFICE PRO 2000)

    AutoFilter has been turned on in the workbook you attached. This is done through Data | Filter | AutoFilter. Select this option to turn AutoFilter OFF. Then select A1:AP1 and select the menu option again to turn AutoFilter ON again.

    Note: normally, you wouldn't have to select a range before turning on AutoFilter, but it is necessary since your table contains empty columns.

  3. #3
    New Lounger
    Join Date
    Nov 2002
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Drop Down List (MS OFFICE PRO 2000)

    OK, well now that I have shown my rear end, thank you! You all are a God Send!

Posting Permissions

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