I'm having problems with auto-complete in Mac for Excel 2010.

I have a long list of data, but it looks as though auto-complete is only looking at the last 121 entries above the cell that I am inputing data in.

In the attached, if you go to the last cell in the column (the yellow cell) and type 'c', you'll notice that the word that is being offered in auto-complete is not the first 'c' in the list. Rather it is the first 'c' about 121 entries above the input cell.

So it looks to me as though there may be a limitation in auto-complete, in that it will only look at the 121 preceding cells.

Does anyone know how I can extend the list to ~300 cells?

Thanks, twobob

autocomplete test.xlsx