| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Set column to only allow certain codes???
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. |
|
#2
|
|||
|
|||
|
You can do this with Data Validation. There are instructions in Excel's
Help files, and he http://www.contextures.com/xlDataVal01.html 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. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Only Allowing Certain Codes In Column | Excel Discussion (Misc queries) | |||
| what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
| how to fit my column unmoved eventhough i scroll down? | New Users to Excel | |||
| Copying the contents of a column into a chart | Excel Worksheet Functions | |||
| How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions | |||
Linear Mode
