I'm trying to create a drop down list with different priorities for clients to choose from (high, medium, low) but I would also like to have a blank as an option. How can I do this?
I am using 2007 if that matters at all.
What I've tried:
Making a list on a seperate sheet and including a blank cell while defining the name of the list. Whenever I set up the data validation after this it deletes the blank cell and only allows the options high, medium, low.
Any help would be appreciated!
Thanks,
Laura
Bookmarks