|
blank space on dropdown list
How do I create a blank space/row at the top of a drop down list?
|
blank space on dropdown list
hi
set your fill range to have a blank cell at the top. Regards FSt1 "Nichole" wrote: How do I create a blank space/row at the top of a drop down list? |
blank space on dropdown list
I apologize, Im 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: hi set your fill range to have a blank cell at the top. Regards FSt1 "Nichole" wrote: How do I create a blank space/row at the top of a drop down list? |
blank space on dropdown list
Watch this 5 min video:
How to setup a data validation drop down list: http://youtube.com/watch?v=t2OsWJijrOM -- Biff Microsoft Excel MVP "Nichole" wrote in message ... 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: hi set your fill range to have a blank cell at the top. Regards FSt1 "Nichole" wrote: How do I create a blank space/row at the top of a drop down list? |
Blank Space at the top of a drop down list
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 |
Blank Space at the top of a drop down list
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 |
| All times are GMT +1. The time now is 10:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com