Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting from a list
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!!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting from a list
See 'Set data restrictions on cells' to learn about Data/Validation.
In article .com, "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!!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting from a list
What you're seeing is an in-cell dropdown. It is created by clicking
(from the menu) ~Data ~Validation. A window appears, and you in the "Allow" box you choose "List". A separate box appears to allow you to enter the Source range for that list. So to edit the list, you may need to expand the range specified in the Source box, then add items for the in-cell dropdown in the Source range. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting from a list
Thanks to everyone who replied.
After I posted the message, I worked it out!!! 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!!!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting from a list
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!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |