Elegant way to restrict data entry to list of values

[AnansiDesign]

Hi all:

I need to provide a way to restrict data entry on a large range.

For example, I need the first 100 rows of column 1 to only provide
'yes, no' as possible entry values. The first 100 rows of column 2 to
provide 'yes, no, maybe'; the first 100 rows of column 3 to provide
'client, server, unsure', etc ...

I thought about using named ranges linked to drop down controls, but
that would result in many controls (over 300 based on above example) on
the spreadsheet and lead to performance issues.

Can anyone suggest a better way to go about doing this? It would be
nice to be able to click on a cell and be presented with a list from
which to choose which populates the cell after selection.

Thank for you input.

Robert.

 

[Miguel Zapico]

You can use the menu data->validation, if you select list there is a checkbox
for "in-cell dropdown" that will present the list of the values.
The good thing about data validation is that you can select all the cells
and do the validation all at the same time.

Hope this helps,
Miguel.

 

[Roger Govier]

Hi

Take a look at Debra Dalgleish's site for information on how to make
effective use of Data Validation.
http://www.contextures.com/xlDataVal01.html