Predefined cells

[TW2]

I want to set up an excel spreadsheet in such a way that,
for example, in column A, users can only enter USA and
FRN. I will receive this file from a lot of people and
the consistency of data entry will make my consolidation
easier. I know there is a way to have a drop down box (or
something similar) that I can predefined the choices of
value for those cells. Users can only choose in those
cells the values that I already defined. I just do not
know how to do that. Wonder if anyone can help.

 

[Bob Phillips]

Use Data Validation. In Allow, select List, and type your values in there.

For more info on DV, see Debra's page at

http://www.contextures.com/xlDataVal01.html

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)