| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List in Excel
I have som headlines. I would like that in some cells you have to choose
between theese headlines. I have tried to use the "insert list", but i doosn't do what I need... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
List in Excel
Thomas wrote: I have som headlines. I would like that in some cells you have to choose between theese headlines. I have tried to use the "insert list", but i doosn't do what I need... Hi Thomas, Maybe you can use the Validation List feature If you have your list of headlines in a column. Highlight the cell where you want the list. Then go to Data - Validation.. In Validation Criteria under Allow chose List. In Source chose the range with the list of headlines then press OK. This will give you a dropdown in the cell Regards, Bondi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel e-mail list to netscape | Excel Discussion (Misc queries) | |||
| Excel 2003 list of field codes for footers? | Excel Discussion (Misc queries) | |||
| Data Val list Excel 97 fire macro | Excel Discussion (Misc queries) | |||
| Get excel to list values that occur within raw data | Excel Discussion (Misc queries) | |||
| Excel List range, filter arrows disappeared | Excel Discussion (Misc queries) | |||
Linear Mode
