Assuming the dropdown list id Data Validation list.

Include the blank cell at the top of your listrange.

i.e. list of choices for list is A2:A12

Select A1:A12 for the listrange.


Gord Dibben MS Excel MVP

On Fri, 06 Nov 2009 07:04:30 -0800, alma st Louis wrote:

Please help!!!!!!!

I am creating a drop down list in Excel and i need to leave a blank space at the top of the list.

Thanks.



Nichol wrote:

blank space on dropdown list
07-Nov-08

How do I create a blank space/row at the top of a drop down list?

Previous Posts In This Thread:

On Friday, November 07, 2008 10:42 AM
Nichol wrote:

blank space on dropdown list
How do I create a blank space/row at the top of a drop down list?

On Friday, November 07, 2008 11:04 AM
FSt wrote:

hiset your fill range to have a blank cell at the top.
hi
set your fill range to have a blank cell at the top.

Regards
FSt1

"Nichole" wrote:

On Friday, November 07, 2008 1:18 PM
Nichol wrote:

I apologize, I???m still learning!
I apologize, I???m still learning! I understand how to select the data I want
and name the list within the name box. Can you please explain how to set the
fill range? Thank You!!!

"FSt1" wrote:

EggHeadCafe - Software Developer Portal of Choice
EggheadCafe.com MSInfo C# Webservice
http://www.eggheadcafe.com/tutorials...-msinfo-c.aspx