| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
applying dropdown list entry to multple cells
Is there a way to get the entry from a dropdown list to apply to multple
cells? All the selected cells have the same list set in their validation rules, but simply selecting many cells and picking from the list in one does not work. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
applying dropdown list entry to multple cells
Select your cells, select the value on one drop down, then press F2 and
Ctrl-Enter. HTH, Bernie MS Excel MVP "twild" wrote in message ... Is there a way to get the entry from a dropdown list to apply to multple cells? All the selected cells have the same list set in their validation rules, but simply selecting many cells and picking from the list in one does not work. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select cells in dropdown list by keyboard | Excel Discussion (Misc queries) | |||
| Revised Dropdown list not applying to some rows | Excel Discussion (Misc queries) | |||
| Preventing manual entry in dropdown list ... possible? | Excel Discussion (Misc queries) | |||
| Dropdown list with named cells | Excel Worksheet Functions | |||
| HOW TO GET DROPDOWN LIST TO LINK TO OTHER CELLS? | Excel Discussion (Misc queries) | |||
Linear Mode
