Add Blank in Data Validation List

This post will guide how to add blank as one option in the data validation list in excel. How do I add a blank in data validation list. How to add a data validation drop-down list with empty cell as an option in excel. How to put a blank option into a data validation list as the first option of the drop-down list in excel.

Add Blank in Data Validation List


If you have a list of data in your worksheet and you have created one data validation drop-down list and you want to put a blank into the existing data validation list as the first one option in the drop-down list. You can do the following steps:

#1 you need to add one blank cell above the data list that be used to create a data validation list.

add blank in data validaton list1

#2 select one blank cell that you want to add the data validation list. Such as: Cell C1

#3 go to DATA tab, click Data Validation command under Data Tools group. The Data Validation dialog will appear.

add blank in data validaton list2

#4 select List option form the drop-down list of Allow list box, and uncheck the checkbox of Ignore blank, then select the source cell.

add blank in data validaton list3

#5 click OK button.

add blank in data validaton list4

You will see that a blank option has been added into the data validation list.

 

 

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar