Site icon Kaizen.Personal computer work.

How to put a blank in the first candidate in the pull-down.(Microsoft Excel)

Japanese version.

If you want to include a blank space as a choice in a pull-down menu (drop-down list), there are
There 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.

Exit mobile version