KutoolsforOffice — One Suite. Five Tools. Get More Done.March Sale: 20% Off

Create a drop-down list from manually entered values in Excel

AuthorAmanda LiLast modified

A drop-down list in Excel is a practical way to control data entry and keep worksheet values consistent. When the list items are simple and do not need to come from a cell range, you can create the drop-down directly by typing the values manually. This method is especially useful for short, fixed lists such as High, Medium, Low, Yes, No, or Pending, Approved, Rejected.

Drop-down list in Excel

Although the source values are entered manually when setting up the list, the finished result is still a normal Excel drop-down list. That means users can choose only from the predefined options, and values outside the list are not accepted under the default validation settings. This makes the method a good choice when you want both simplicity during setup and control over what users can enter.

In this tutorial, we will show two reliable ways to create this kind of drop-down list in Excel. The first uses Excel’s built-in Data Validation feature, while the second uses Kutools for Excel to speed up the process with a more guided interface.

Create a drop-down list with manually entered values using Data Validation

Excel’s built-in Data Validation feature is the standard way to create a drop-down list. If your list is short and fixed, you can type the source values directly into the Source box instead of preparing them in worksheet cells.

  1. Select the cell or range where you want to add the drop-down list.
  2. Go to the Data tab, then click Data Validation in the Data Tools group.
    Data Validation option on the ribbon in Excel
  3. In the Data Validation dialog box, stay on the Settings tab.
  4. From the Allow drop-down list, choose List.
  5. In the Source box, type the list items separated by commas. For example:
    • High, Medium, Low
    • Yes, No, Maybe
    • Approved, Rejected, Pending
  6. Make sure In-cell dropdown remains checked.
  7. Click OK.
    Data Validation dialog box

Excel will immediately create a normal drop-down list in the selected cell or range. Users can click the arrow to choose one of the listed items, and under the default validation settings, entries outside the list will not be accepted.

Drop-down list added in a list

Note:

When entering source values manually, use commas to separate each item. This method works best for short lists that do not need to be updated often.

Pros

  • Built into Excel, so no add-ins are required
  • Quick to set up for short fixed lists
  • Helps prevent invalid or inconsistent entries

Cons

  • Less convenient if the list needs frequent updates
  • Longer lists are harder to manage when typed manually

Quickly create a drop-down list with manually entered values using Kutools for Excel

If you prefer a more guided setup, Kutools for Excel provides a dedicated feature for creating drop-down lists from manually entered values. Beyond basic list creation, it also offers more advanced drop-down capabilities, making it a good choice for users who want both ease of use and added functionality.

Kutools for Excel offers over 300 advanced features to streamline complex tasks, boosting creativity and efficiency. Integrated with AI capabilities, Kutools automates tasks with precision, making data management effortless. Detailed information of Kutools for Excel...         Free trial...
  1. After downloading Kutools for Excel, select the cell or range where you want to add the drop-down list.
  2. Click Kutools > Drop-down List > Quickly Create a Dropdown List.
    Data Validation option on the ribbon in Excel
  3. In the Quickly Create a Dropdown List dialog box, select Manually Enter Values.
  4. In the Please enter content box, type the source values separated by commas. For example:
    • High, Medium, Low
    • Yes, No, Maybe
    • Approved, Rejected, Pending
    Data Validation option on the ribbon in Excel
  5. Click OK.

Kutools will create the drop-down list instantly for the specified range. Like a standard Excel drop-down list, it is designed to allow only the predefined values in the list.

Drop-down list added in a list

Note:

Please use commas to separate each list item when entering the values manually. This method is most suitable for short, fixed option lists.

Optional: Enable auto pop-up for the drop-down list

Kutools for Excel also provides an option to make the drop-down list open automatically when you click a cell that contains the list, as shown in the screenshot below. This can make selection faster and more convenient, especially when you need to work with multiple drop-down cells in a range.

The drop-down list opens automatically when clicking a cell
  1. When creating the drop-down list in the Quickly Create a Dropdown List dialog box, check the Automatically pop up drop-down list option.
    Quickly Create a Dropdown List dialog box
  2. To make this feature work properly, you also need to go to the Kutools tab, click Drop-down List, and then check Enable All Drop-Down Lists to Be Searchable and Auto-Expandable.
    Enable All Drop-Down Lists to Be Searchable and Auto-Expandable option on the Kutools tab on the ribbon

After both options are enabled, the drop-down list will pop up automatically whenever you select a cell that contains the list. You can then search for an item or click directly to choose it more efficiently.

Pros

  • More user-friendly than manual setup
  • Supports automatic pop-up and searchable drop-down behavior
  • Convenient for users who work with drop-down lists often

Cons

  • Requires Kutools for Excel

Kutools for Excel - Packed with over 300 essential tools for Excel. Make Excel tasks faster, easier, and more efficient. Download now!

Frequently asked questions about Excel drop-down lists

What kind of lists is manual entry best for?

Manual entry works best for short and fixed lists that do not change often, such as priority levels, approval status, or yes/no options.

Can users enter values that are not in the drop-down list?

No. A drop-down list in Excel only allows values from the predefined list. If a user types a value that is not included, Excel will not accept it unless the validation settings are changed.

Is the drop-down list case-sensitive?

Yes. An Excel drop-down list requires an exact match. For example, if the list contains Low, typing low will not be accepted because it does not match the original capitalization.

What happens if I need to change the list items later?

You will need to edit the drop-down source manually. Open the validation settings or the Kutools dialog again, then update the items in the list.

Can I copy a cell with a drop-down list to other cells?

Yes. You can copy the cell and paste it into other cells to apply the same drop-down list. This is a quick way to reuse the same list without creating it again.

Can Excel’s built-in drop-down list pop up automatically or support search?

No. Excel’s built-in drop-down list does not support automatic pop-up when a cell is selected, and it does not provide a built-in search feature for list items. If you need these advanced abilities, tools such as Kutools for Excel can provide them.

Conclusion

When you need a normal Excel drop-down list that allows only predefined values, manually entering the source items is a simple and effective approach. It works especially well for short lists that are unlikely to change, such as status labels, priority levels, or approval options.

If you prefer Excel’s built-in tools, Data Validation gives you a reliable way to create the list directly. If you need more advanced drop-down features, Kutools for Excel provides a more powerful solution with extra capabilities beyond the standard method.

I hope you found this tutorial helpful. If you’d like to explore more Excel tips and practical solutions, please click here to browse our full collection of Excel tutorials.