AUTOFILL with specific range

[Sunil Patel]

I want to reduce the amount of typing i need to do.
ie when i type "dor" in cell a1 on sheet 1 , i need "Dorothy" to appear, as
"Dorothy" is listed on sheet 2 in column 1- autofill of sort . Is thi
possible ?
I have tried data validation but find font and list size of 8 a problem.

Sunil

 

[Dave Peterson]

Maybe just typing dor and then edit|replace with what you want.

Or...

turn on autocomplete
tools|options|edit tab|enable autocomplete for cell values

or...

use a combobox from the control toolbox toolbar.