How do i select data from a validation list without scrolling?

[Ramchi]

I need to execute data from a large validation list whithout having to scroll
for ages to find what i need.

 

[Gord Dibben]

Ramchi

DV list length cannot be changed from the default 8 items.

For work-arounds see Debra Dalgleish's site for a Free download of a workbook
showing how to use a Combo-box in conjunction with the DV cell.

http://www.contextures.on.ca/xlDataVal08.html#Font


Gord Dibben Excel MVP