drop down list - blank option

[Alphazulu]

Any idea how to include a blank option in a drop down list without using a group of cells including one blank cell.

I'd like to have the list independent of a list saved within a range of cells

 

[texasalynn]

you can type your list into the list source box. Uncheck the ignore blank
1st, 2nd, 3rd, ,

 

[T. Valko]

you can type your list into the list source box. Uncheck the ignore blank
1st, 2nd, 3rd, ,

That doesn't work for me.

 

[texasalynn]

That's weird it works for me. Do you get any errors or you just don't see a blank after the 3rd item?

 

[T. Valko]

That's weird it works for me. Do you get any errors or you just don't see a blank after the 3rd item?

No errors and no blank after the 3rd item.

Tried it in both Excel 2002 and 2007, with and without Ignore blank checked.

 

[texasalynn]

No errors and no blank after the 3rd item.

Tried it in both Excel 2002 and 2007, with and without Ignore blank checked.

\
The first time it works, then when I go back it doesn't work. So with that the only option would be to create the list including a blank cell and then range name it. I know you said that you didn't want that, but not seeing any other solution. Put your list on another sheet, then you could hide the sheet if that's an issue.

 

[moniqueaki]

</gs>you can type your list into the list source box. Uncheck the ignore blank
1st, 2nd, 3rd,<gs id="32969027-d066-43be-96ff-f92b68b4ccfa" ginger_software_uiphraseguid="ac524009-e014-48b5-b55b-e01c7c489407" class="GINGER_SOFTWARE_mark"> ,</gs>

If it is not <gs id="b3bb94b5-8ded-4e23-b7bc-256e16bda432" ginger_software_uiphraseguid="1c48e860-5138-4132-9220-0fbd47ad7896" class="GINGER_SOFTWARE_mark">working try</gs> this in the data validation tab

1. Select all the data validation cells
2. On the Ribbon, click the Data tab, and click Data Validation
3. Click the Error Alert tab
4. Remove the check mark from "Show error alert after invalid data is entered"
5. Click OK to close the Data Validation box.