Auto fill in

T

TQ

Hi,
I discover that when I type some word that already exist,just half way I
type the word then it will automatic show the following word in highlighted.

Is this setting problem ? If yes where should I choose the function ?
 
G

Gord Dibben

Tools>Options>Edit

Enable Autocomplete for Cell Values.

Check or uncheck. Whatever you want.


Gord Dibben MS Excel MVP
 
M

Max

Presuming you want to disable it ..
Click Tools > Options > Edit tab
Uncheck "Enable AutoComplete for cell values" > OK
 
Top