How to Make a Header Drop Down List in Excel | Scribe

    How to Make a Header Drop Down List in Excel

    • Adrienne Todd |
    • 10 steps |
    • 58 seconds
      1
      Click on the cell you'd like to add a dropdown list to.
      2
      Click on the "Data" tab.
      3
      in the "Data Tools" section of the ribbon, click the arrow next to the data validation icon.
      4
      Click "Data Validation..." in the dropdown.
      5
      Click on the dropdown for "Allow."
      6
      Click on "List."
      7
      Click on the "Source" dropdown.
      8
      Type the text you'd like in your dropdown list.
      9
      Click "OK."
      10
      To view your new dropdown, click on the arrow in the cell you've added the dropdown to.