Buttercup
Data Validation is problay what you need.
See here for instructions.
http://www.contextures.on.ca/xlDataVal01.html
Gord Dibben Excel MVP
On Thu, 6 Jan 2005 11:25:03 -0800, Buttercup
wrote:
In my spreadsheet, I would like to set a column so that it will only allow
certain codes. For example: I would like only the following written exactly
as is here to be allowed to be entered into a column:
AUTO
HOME
DP-3
DP-2
How can I set the column to only allow these & can I make it so it will
display the codes for the user.
Thank you.