PC Review


Reply
Thread Tools Rate Thread

Data Validation Boxes

 
 
adjp102
Guest
Posts: n/a
 
      5th Nov 2003

I used the list option under Data Validation and can only see the
dropdown boxes, when I click on the cells.

How can I make the dropdown boxes visible all the time.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

 
Reply With Quote
 
 
 
 
Debra Dalgleish
Guest
Posts: n/a
 
      5th Nov 2003
The Data Validation dropdown arrow is only visible when the cell is
active. You could use fill colour or a comment to indicate that the cell
has data validation.


adjp102 wrote:
> I used the list option under Data Validation and can only see the
> dropdown boxes, when I click on the cells.
>
> How can I make the dropdown boxes visible all the time.



--
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
Data validation on combo boxes Pristan Microsoft Excel Programming 1 19th Jun 2008 09:53 PM
Data validation boxes, outputting a final number from the boxes =?Utf-8?B?TURI?= Microsoft Excel Misc 1 16th Nov 2006 12:41 AM
Input Boxes and data validation John Microsoft Excel Discussion 1 7th Jul 2006 02:30 PM
Check Boxes & Data Validation =?Utf-8?B?TWlrZSBS?= Microsoft Excel Misc 4 4th Oct 2005 06:47 PM
Data Validation list boxes Watson Microsoft Excel Misc 4 26th May 2005 05:12 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:32 AM.