Limit to AutoComplete?

[karrowr]

Is there some sort of row limit for AutoComplete? I've pasted 85 rows above a column. When Ii go to the bottom of the column and begin typing, sometimes it will AutoComplete and sometimes it won't. Does the program only look at the last 20 rows or something?

 

[Von Pookie]

It can be rather picky at times. I think most of it depends on what is actually entered into the cells above it, but the Excel help file states the following which may help/apply here:

Microsoft Excel doesn't always complete my column entries.

Make sure AutoComplete is turned on
On the Tools menu, click Options, click the Edit tab, and then make sure the Enable AutoComplete for cell values check box is selected.

Check where you last clicked
Click after the last character in the cell. Excel completes an entry only when the insertion point is at the end of the current cell contents.

Make sure entries match
The characters you typed might not match an existing entry in the column, or the characters might match two or more entries. For example, if you type AXY and the possible entries are "AXY1" and "AXY2," Microsoft Excel does not complete the entry.

Select the correct entry
To select the entry you want, press ALT+DOWN ARROW and select an entry from the list, or right-click the cell and then click Pick from list on the shortcut menu.

Entries in a row
Excel bases the list of potential entries on the column that contains the active cell. If your entries are repeated within a row, not a column, the entries are not completed.

Numbers, dates, and times
Excel completes only text entries. Entries that contain only numbers, dates, and times are not completed.

The current data region
Check the location of the active cell; it may be outside the current data region. For example, if the data region is the range of cells A1:E10, Excel completes an entry typed in cell A11, even if the cell A10 above it is blank. However, Excel does not complete an entry in cell A12, because that cell is outside the data region.

Long lists
If you are working in a large list, you may need to pause a moment to allow Excel time to complete an entry.

Hope it helps,