Drop Down | Starting Location | Excel 2010

[John Jahn]

Drop down box when click starts at the 1st blank after video, would like to start at ADA. be aware, I know just enough to cause trouble & confusion.



List "Type1" - Under Video have several blanks for future
<table border="0" cellpadding="0" cellspacing="0" width="60"><col style="width: 45pt;" width="60"> <tbody><tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt; width: 45pt;" width="60" height="15">ADA</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">Audio</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">Bag</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">Cable</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">Connector</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">Control</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">Display</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">Extender</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">Infrastr.</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">Install</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">Interactive</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">Lights</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">Mic</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">Mount</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">Plate</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">Power</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">Rack</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">Source</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">Speaker</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">Video</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl67" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl66" style="height: 11.25pt;" height="15">
</td> </tr> </tbody></table>

 

[Ruddles]

Is this a Data Validation list? A ListBox? A ComboBox? A Form control? An ActiveX control? On a worksheet? On a userform?

 

[John Jahn]

Data Validation

 

[Ruddles]

Define your named range to include only the populated cells. When you make room to insert new entries in alphabetical order in the list, the named range will 'stretch' accordingly.