Auto Complete not working in one column

[Lisa]

I have Excel 2007. I'm entering data into 3 colums. Auto Complete is not
working for one of my colums. It was when I first started and I can't figure
out how to get it going again. I am entering a City and state in this column
and I want it to complete when I type in the first letter like it was doing.
It is still working fine on names I'm entering into the other colums.

What am I missing? Thanks!

 

[Sheeloo]

There might be a blank cell in the column with the problem... It does not
look beyond blank cells...

Type something in a cell and start typing the same thing in the cell
immediately below... does it work? If yes, then look for a blank cell in the
column.

 

[Woot]

I am experiencing the same problem with auto complete not working in one
column. I looked for blank fields and found none. Any other ideas? This
function was working at one time but is not working now.

 

[Sheeloo]

Excel 2003
Choose Tools->Options
Go to Edit TAB
Make sure 'Enable Autocomplete for cell values' check box is CHECKED