How to create drop down list?

A

aheitner

How do I create a cell such that the user has to select from one of
selections in a drop-down list?

For example, column A is called "Contract Length" In each of the cell
of column A, I'd like the user to select from only 3 choices: 12, 24
36.

Thanks,

Andre
 
R

Rollin_Again

You can use the DATA VALIDATION feature. Here's how:

First enter the available values you would like to appear in the dro
down list in several cells. For example enter 12, 24, and 36 in cell
B1,B2, and B3 respectively. Next click on Cell A1 and choose DATA --
VALIDATION from the menu at the top of the Excel Workbook. Whe
prompted for the ALLOW values click the drop down menu and selec
"LIST." After selecting "LIST" you will be allowed to select th
source of your validation list. Just click the icon to the right o
source textbox and you can then click and select the range of value
you previously entered in cells B1 through B3.



Rolli
 
D

Debra Dalgleish

You can use Data Validation.

Select the cells in column A
Choose Data>Validation
From the Allow dropdown, choose List
In the Source box, type: 12,24,36
Click OK
 
D

Dave Hawley

Hi AH

You can hide only entire Columns or Rows, not individual cell. Select
the Column letter heading and go to Format>Column>Hide

You can also type the entries direct into the souce list box, if it's
not too long. Just seperate each item with a comma, e.g
Cat,Dog,Rat,Mouse etc

You can also use a range from another Worksheet for the List Source. To
do this simply highlight the list entries, then click in the "Name Box"
(left of the Formula bar) and type a one word name, e.g MyRange Now in
the List Source box enter: =MyRange

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
 
Top