Greetings:
I've made a drop down list that refers to another spreadsheet in the same workbook. Code is;
='Status Options'!$A$1:$A$5
A1 and A5 is blank. I want the blank option for users to clear their selection---however when I save it no longer lists the blank options in the drop down menu. Is there a way to force it to list the blank as well? Thanks.
Bookmarks