ghjs
asked on
EXCEL COMBO BOX ON EACH LINE WITH DATA POPULATED ALREADY
Hello,
I know how to create combo boxes in ctrl and forms. But they don't seem to be directory associated with a row. Rather they are more graphical and can move about but still showing data and working with the spreadsheet. I'm looking for a solution so that if i were in Column B I could down arrow through the entire spreadsheet and I would have a combo box show when I down arrow. Then I could just click my selection. I have a spreadsheet that has this from someone. I've yet to figure out how they've done this. Now I need it bad. Thanks all...so much
Take care
I know how to create combo boxes in ctrl and forms. But they don't seem to be directory associated with a row. Rather they are more graphical and can move about but still showing data and working with the spreadsheet. I'm looking for a solution so that if i were in Column B I could down arrow through the entire spreadsheet and I would have a combo box show when I down arrow. Then I could just click my selection. I have a spreadsheet that has this from someone. I've yet to figure out how they've done this. Now I need it bad. Thanks all...so much
Take care
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Creating a drop-down menu
Lynda Morris, president of NicLyn Consulting Corp, an Internet-based computer and network service company, often finds herself entering the same information or formulas in different parts of a spreadsheet. Instead of typing data repeatedly, she creates drop-down menus that save typing time. To create a drop-down menu:
• Open a worksheet and label your menu (Days for example) in the top cell of a column.
• Enter data (days of the week, in this case) in the cells below the label (such as A2 to A8).
• Highlight the list, including the label.
• Click the Insert menu, then click Name, and then Define.
• In the box under Names in workbook you will see the name of the range (Days). In the Refers to box, it should list "=Sheet1!" followed by the range (=Sheet1!$A$1:$A$8).
• Click Add and then OK.
• Select any cell or range of cells in which you want to enter data.
• Click the Data menu and then Validation.
• From the Allow drop-down menu, select List. In Source, type "=" and the name of your range (=Days). Make sure that the In-cell dropdown box is checked.
• Click one of the cells you highlighted to see your drop-down menu. Choose the item you want to enter in the active cell. Enter data from your list, in any order, in each of the cells you selected.