Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
DataValidationAllowList
Gord Dibben MS Excel MVP On 23 Aug 2006 08:11:26 -0700, "Duncs" wrote: I consider myself knowledgeable in Excel, but this has me beat! I've inherited a spreadsheet from a colleague which I have to modify. When I click in any cell within the spreadsheet, a drop-down arrow appears next to it. Clicking on this brings up a list of seven entries. I know the drop-down list is not the one from the Controls Toolbox, nor is it the combo box. The drop-down list appears within the cell, with the drop-down arrow just to the right. I need to add a couple of other options, which means adding two more drop-down...but I haven't a clue how to add them! HELP!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you find the list option in excel on office xp | Excel Worksheet Functions | |||
Help! Selecting item on data validation list switches windows | Excel Discussion (Misc queries) | |||
Matching Lists Where List Size is Unequal | Excel Discussion (Misc queries) | |||
Selecting items from a list. To transfer to another worksheet? | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) |