Drop Down List in Excel Cell

To make a Drop Down List in a Excel cell,

  1. Select the cell
  2. Data Menu
  3. Click Validation
  4. For the drop down list Allow, choose LIST
  5. In the text box Source add items separated by comma.
  6. Click OK

Did you enjoy this article?
Signup today and receive free updates straight in your inbox. We will never share or sell your email address.

Leave a Reply