Help

[rjc_29]

I am trying to create a spreadsheet where data is inputted but the
content of certain columns is restricted to certain text values which
can be selected by the inputter. For example:
column A:
ES, EW, EE, SH, SR

Column B:
Yes or NO

Column C:
Crime, Evidence, Drugs or Other

The column names are just as examples. Does anyone know how this can
be done?

 

[Guest]

It seems like you need to use Data Validation.

Check Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html

Does that help?

***********
Regards,
Ron

 

[Guest]

Look under Data / Validation...

 

[Guest]

Try Data menu | Validation. You can use this to restrict values in selected
cells. Be sure to select properly. Add column labels describing the data,
then select the entire column before running the menu option to ensure the
restrictions apply to all cells in that column.

 

[Vito]

Go To Data|Validation and choose to allow: List

Enter the values of the list in the source box separated by commas