Excel – Create Cell Dropdown menu

  1. Data
  2. Data Validation
  3. In Settings tab -> Validation Critera
  4. Allow: List (Tick “Ignore Blank” and “In-cell dropdown”)
  5. Source: Select the source list
  6. Click Ok

Leave a Comment

Your email address will not be published.

Free Web Hosting