how to insert blank space in data validation?

April 28, 2009 at 11:18:46
Specs: Windows XP
how to insert blank space in data validation list in excel 2007. I'm aware i can choose a range withh a blank cell, i'm looking to type the value in the box.

See More: how to insert blank space in data validation?

Report •


#1
April 28, 2009 at 11:48:38
In 2003 you can enter a final comma and then a space and uncheck the "Ignore blank" option.

I'm not sure if you can place a blank in the middle of a drop down list unless you use a range of cells.


Report •
Related Solutions


Ask Question