How to make a drop down list in excel 2007

HOW TO MAKE A DROP DOWN LIST IN EXCEL 2007 HOW TO

Some will be at the start, or the middle, or the end, or somewhere else. Why I want to use the ctrl+f is due to that some of the names that will be needed to be selected will have the same part of text just in different spots in the names. I don't know if recording a macro will tell me where ctrl+f stores the list temporarily or not, that is the next I was think that if there was some way to use the list that is generated by the ctrl+f 'find all' then that really would be usefully. I have a list of names (~600) and I need to have the ability for multiple selection but I also would like the added effect that the user can type in part of the name and it populate the list form the matching text that was entered.

I have the same idea as Badal but a little different. If anything is unclear or if there is anything I can do for you, please feel free to let me know. Please take your time to try the suggestion and let me know the result at your earliest convenience. ListFillRange=вЂ™Sheet1вЂ™!A1:A5 (A1:A5 is just for example, please fill it with your own range) In the Properties make the following changes: Right click on it, and select Properties. You'll see the list range in the Source box. On the Settings tab, click in the Source box, and then on the worksheet that has the entries for your drop-down list, Select cell contents in Excel containing those entries. Turn on Design Mode by clicking on the Design Mode button(located at Controls ribbon).Д¬lick on Insert button, in the drop down list select the List Box(ActiveX Control), draw the box wherever you want. On the worksheet where you applied the drop-down list, select a cell that has the drop-down list. (If the Developer tab is not available, go to Option->Popular->Top options for working with Excel->Show Developer tab in the Ribbon)

HOW TO MAKE A DROP DOWN LIST IN EXCEL 2007 HOW TO

IвЂ™m sorry, but as far as I know, there is no way to put a multiple selection in a drop down list.Д«ut I can show you how to create a multiple selection in a scroll list, hope it still helpful. Thank you for using Microsoft Office for IT Professionals Forums.

How to make a drop down list in excel 2007