PC Review


Reply
Thread Tools Rate Thread

create a drop down list

 
 
=?Utf-8?B?SGFycGVy?=
Guest
Posts: n/a
 
      22nd Feb 2006
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
 
Reply With Quote
 
 
 
 
Chip Pearson
Guest
Posts: n/a
 
      22nd Feb 2006
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



 
Reply With Quote
 
Debra Dalgleish
Guest
Posts: n/a
 
      22nd Feb 2006
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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:10 PM.