Thread: Auto fill in
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Auto fill in

ToolsOptionsEdit

Enable Autocomplete for Cell Values.

Check or uncheck. Whatever you want.


Gord Dibben MS Excel MVP

On Tue, 9 Jan 2007 18:21:01 -0800, TQ wrote:

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 ?