create a drop down list

's Computer Specifications

I have created a drop down list using the Data Validation tool. However i
can not get a title ion the cell or the drop down arrow to always show, any
ideas

's Computer Specifications

Ensure that you have "In-cell Dropdown" checked.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Harper" <(E-Mail Removed)> wrote in message
news:ADE3F70E-6A3A-44F5-8571-(E-Mail Removed)...
>I have created a drop down list using the Data Validation tool.
>However i
> can not get a title ion the cell or the drop down arrow to
> always show, any
> ideas

's Computer Specifications

The dropdown arrow only shows when the cell is active.
You could add "'--Select Name--" as the first item in the list, and
choose it as the default entry in the cell.

Harper wrote:
> I have created a drop down list using the Data Validation tool. However i
> can not get a title ion the cell or the drop down arrow to always show, any
> ideas

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Drop down lists that auto create and then filter the next drop down list	penderyn123@googlemail.com	Microsoft Excel Worksheet Functions	2	30th Sep 2007 11:53 AM
How to Create a macro from drop down list (Validation List) in excel	rajashekar14@yahoo.com	Microsoft Excel Programming	0	31st Oct 2006 12:42 PM
How do I create a Drop Down List with Hyperlinks as List Items in ASP.NET	Tony Tone	Microsoft ASP .NET	2	28th Apr 2006 08:33 PM
Can I create a drop-down list that will reference other drop-down	=?Utf-8?B?ZmRlYmVsbw==?=	Microsoft Excel Worksheet Functions	3	7th Jan 2006 09:34 AM
How to create drop down list that determines another drop down list?	Darren D.	Microsoft Excel Misc	2	4th Dec 2003 03:12 AM