Set column to only allow certain codes???

B

Buttercup

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA word change keys 0
Excel does not accept text format! 0
Mail Merge Directory Conditional Page Break 0
ASK Field Formatting 1
Prompt For Replace in Selection And More... 0
Need Help with a VBA subroutine 0
beginner sql query 0
beginner : SQL in access 1

Top