Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Drop down menus
I learnt how to do drop down menus for cells, but I would like the drop down
menu to display one word but enter in a different character in the cell when it is selected. |
#2
|
|||
|
|||
There's a sample workbook on my web site that shows a product name and
code in the Data Validation dropdown list. After an item is selected, the cell shows only the product name. You should be able to adapt this to your workbook. On the following page: http://www.contextures.com/excelfiles.html Under the data validation heading, find 'Data Validation "Columns"' and download the file named DataValNameID.xls Please help wrote: I learnt how to do drop down menus for cells, but I would like the drop down menu to display one word but enter in a different character in the cell when it is selected. -- 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 | |||
How do you create dual drop down menus in excel 2000? | Excel Discussion (Misc queries) | |||
Adding drop down menus to a spreadsheet | Excel Worksheet Functions | |||
Drop Downs Menus | Excel Worksheet Functions | |||
drop down menus in excel | Excel Discussion (Misc queries) | |||
how do you create drop down menus for individual cells in excel? | Excel Worksheet Functions |