Excel Drop Down
Multi Option

Excel Drop Down Multi Option

includes

​

View Single or Multiple Columns

Selection of Single or Multiple Rows

​

Searching Within All Columns

​

Add New Row To List

(on the fly)

​

• Fast Search - type a letter, string, word or phrase

• Multi Search - for multiple words and phrases 

• Smart Search - dynamic filtering, as you type

• Sort Buttons - sort alphabetically A-Z & Z-A

• Duplicates Buttons - show / hide duplicates

• Scroll Bars - fast scrolling rows and long text 

• Tab and Enter key - save and select next cell

• Clear & Delete Buttons - to clear selection

• Larger Font - faster to read, easier to read 

• More Rows To See - 16 rows instead of 8

• See the validation range in window header

• Default Options To Automatically: sort drop down, hide duplicates, choose font size increase

​

Select "Multi" Options With A

Named Range

​

Single or Multiple Columns In View

(up to 4 columns - returns column 1)

​

Single or Multiple Selection of Rows

​

Sort Rows, Hide Duplicates

​

Skip Hidden Rows

​

BONUS FORMULA FUNCTIONS

​

Clean String, Sound System Beep, Get Hyperlink,

Get Last Used Row / Column, Get Formula,

Get Workbook Path, Does File / Sheet Exist

​

GetMultiSelectionN - return individual selections within a cell (from multiple selections)

​

​

​

​

​

​

​

​

System Requirements

Please Check These Before Ordering

User & Technical Support

• Up to 99 Columns
   

• Display A Photo, Image, or PDF File
   

• Open a Document or Web Page
   

• Choice of Returning 

        - 1st, 2nd or Last Cell

        - Hidden Description

        - Hidden Product Code
 

• Add New Row Button (on the fly)