PC Review


Reply
Thread Tools Rate Thread

Drop-Down-Menue

 
 
Harald Staff
Guest
Posts: n/a
 
      3rd May 2005
Hi Aris

Inside a cell it's done with Data validation. See
http://www.contextures.com/xlDataVal01.html
on this.

There are also combobox controls in the Controls toolbox and in the Forms
toolbar.

HTH. best wishes Harald

"Aris Koustoudis" <(E-Mail Removed)> skrev i melding
news:(E-Mail Removed)...
> Hello everyone,
>
> how do you create a drop-down menue in a specific cell in Excel?
>
> I refer to those kind of drop-down menues, that are commonly used on many
> web-pages,
> where you can choose between different pre-given alternatives.
>
> thanks in advance
>
> Aris
>
>



 
Reply With Quote
 
 
 
 
Niek Otten
Guest
Posts: n/a
 
      3rd May 2005
Hi Aris,

Please fix your system date

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Aris Koustoudis" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello everyone,
>
> how do you create a drop-down menue in a specific cell in Excel?
>
> I refer to those kind of drop-down menues, that are commonly used on many
> web-pages,
> where you can choose between different pre-given alternatives.
>
> thanks in advance
>
> Aris
>
>



 
Reply With Quote
 
CLR
Guest
Posts: n/a
 
      4th May 2005
Select an out of the way column and create your list that you want to
drop-down..........then select the cell where you want the dropdown to
appear and then do Data > Validation > SettingsTab > Allow: choose "List" >
click on the Source: arrow and then highlight your prepared list, > then
click the arrow on the DataValidation pop-up > then be sure the
In-cellDropdown box is checked > OK..........

Vaya con Dios,
Chuck, CABGx3


"Aris Koustoudis" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello everyone,
>
> how do you create a drop-down menue in a specific cell in Excel?
>
> I refer to those kind of drop-down menues, that are commonly used on many
> web-pages,
> where you can choose between different pre-given alternatives.
>
> thanks in advance
>
> Aris
>
>



 
Reply With Quote
 
Aris Koustoudis
Guest
Posts: n/a
 
      4th May 2005
Hello everyone,

how do you create a drop-down menue in a specific cell in Excel?

I refer to those kind of drop-down menues, that are commonly used on many
web-pages,
where you can choose between different pre-given alternatives.

thanks in advance

Aris


 
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 menue and autofills leslie Microsoft Excel Misc 4 9th Jan 2009 06:44 PM
vb drop down menue conorot Microsoft Excel Misc 1 17th May 2006 11:03 AM
Re: DROP DOWN MENUE Debra Dalgleish Microsoft Excel Misc 1 4th Feb 2004 04:50 AM
Re: DROP DOWN MENUE Lady Layla Microsoft Excel Misc 0 3rd Feb 2004 08:43 PM
Re: DROP DOWN MENUE Peo Sjoblom Microsoft Excel Misc 0 3rd Feb 2004 07:50 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:54 AM.