Japanese version. If you want to include a blank space as a choice in a pull-down menu (drop-down list), there areThere are some restrictions and cannot simply be set. Procedure Prepare a blank cell at the beginning of the candidate values. Enter a space or =”” in the top cell. Set up a list like the one below. Specify a range of cells, including blank cells, for Data Validation and “Source”. Links Tips. Others.(Microsoft Excel)