Help with Autocomplete when typing

  • Thread starter Thread starter TBA
  • Start date Start date
T

TBA

Somebody has used my computer while I was gone (grrr....) and no Excel is
not autocompleting certain words that repeat regularly. Suppose in Column B
I have to manually type in either YES or NO. Usually once a few have been
entered all I have to do is type in the Y or the N and the rest of the word
is automatically completed. This is not happening anymore but I would like
it to. Where exactly is this setting? I tried looking in Options and
AutoCorrect... but nothing jumped out at me. Any suggestions?

-gk-
 
TBA,

Tools -> Options
Under the Edit tab check off "Enable AutoComplete for cell values"

Dan E
 
Back
Top