It’s probable that you’ll come into instances where you’ll give your users the option of selecting a bank or a blank value from a Data Validation drop-down list. This update may be regarded as a “good” because users only want to press the Delete or Backspace button on their keyboards to remove the cell. On the other side, We’ve observed that this minor tweak may make the user experience operate a little more efficiently. This happens because the user may be unsure whether or not they are allowed to have an empty value.
Let’s examine the several ways you may have that empty value added to the drop-down list for your Validation.
Add Blank Selection to an Excel Drop-Down List
I’ll add an empty option by pointing to a now-empty cell. Enable me to modify a part for a user that has the identities of numerous banks. Now, in addition to the blank selections, I’ll create a drop-down list to edit this list.
To create a new area rectification list of banks, put an empty cell below the Select Bank list that you intend to use.
Choose the cells to which the data validation list will be added.
Then, from the “Data” menu, choose “Data Validation.”
By accessing the “Data Validation” window and then choosing “List” from the “Allow drop-down list” in the “validation criteria” area, you may create a data validation list using an existing list.
Choose the “Source” box, then add drop-down selections before clicking the OK tab. At this time, you may see that the data validation list option is blank.
To see the dropdown list, press the arrow.
Choose an item from the drop-down menu.
The cell will show the identity of the chosen bank.
You learned how to add an empty selection to an Excel drop-down list in this article. Follow the steps in this article to practice and learn how it performs so that you can easily utilize drop-down lists in Excel when you require them.
How to add blank as first one option in excel data validation list?
Choose the “Source” box, then add dropdown selections before clicking the OK button. At this time, you should see that the data validation list option is empty.
Excel drop down list with custom option
1. Go to the Data tab on the Excel ribbon.
2. Then pick Data Validation from the Data Validation menu.
3. A dialogue box appears.
4. In the Allow menu, choose List.
5. Enter values manually (with a separator) under Source, or pick a range containing the numbers you want to accept from the drop-down box.
How to create a long drop down list in Excel
1. Choose the cells that will house the lists.
2. Click DATA > Data Validation on the ribbon.
3. Set Allow to List in the dialogue.
4. Click in the Source field, input the text or numbers (separated by commas for a comma-delimited list) that you want in your drop-down list, and then click OK.