How to add a blanck for cell Data validation

[WassimN]

Hello Wounderful XLers,

How may I add a blanck cell so that the user can choose to fill a cell with a blanck ranther than force them to pick a value?

I have several cells with data validation applied, and the data validation is based on a list source in a worksheet called "Lists". I have 4 options that the user can pick from, but now they say they need a blanck as the 5th opption.

I tried to make the first cell in the list in the worksheet "Lists" be an empty cell it did not work. I placed a single space in the first cell, it did not work.

I even unchecked the Ignore blancls in the data validation settings dialog, and it did not work?!

What is the workaround tp make this happen?

Thanks for your advice in advance.

 

[Fluff]

if you select List in the DV & set the Source to =$A$1:$A$4 you should be able to select a blank if your data is like

Book1
	A
1
2	RM1
3	RM2
4	RM3
Sheet1

 

[WassimN]

Thanks Fluff

I do have that, but no dice?! When I save the workbook and then go to the cells with data validation, I do not see the blanck on top.

Sorry this is my first time pasting a screen shot, but it did not work. I will read about it and redoing it later in the day.

-- corrupted image removed --

 

[Fluff]

You're right, once saved the blank option disappears.
Try setting your list like this

Book1
	A
1	list
2
3	RM1
4	RM2
5	RM3
Sheet1

And use the formula =$A$2:$A$5