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!

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.

"Lisa" wrote:

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!

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" wrote:

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.

"Lisa" wrote:

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!

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

"Woot" wrote:

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" wrote:

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.

"Lisa" wrote:

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!