XL97: AutoComplete May Not Work

MORE INFORMATION

Example

When you use the steps in the following example, the AutoComplete feature does not appear to function properly.

NOTE: The text strings that are surrounded by quotation marks in the following steps should not be entered with the quotation marks.

1. Save and close any open workbooks, and then create a new workbook.
2. In cell A1 enter ABC in uppercase.
3. In cell A2 type a in lowercase and do not press ENTER.
   
   The AutoComplete feature automatically inserts "aBC" in cell A2.
4. Continue typing abc in lowercase in cell A2, and then press ENTER.
   
   This overwrites the text that is suggested by AutoComplete.
5. In cell B1, enter ABC in uppercase.
6. In cell B2, type a in lowercase and do not press ENTER.
   
   The AutoComplete feature does not automatically suggest "aBC" in cell B2 as it does in step 3.

Because the characters in cell A1 are all uppercase, and the characters in cell A2 are all lowercase, Microsoft Excel determines that Row 1 is a list header row. The algorithm for the AutoComplete feature does not generate suggested text if the first row is considered a list header row. This behavior also occurs if characters in cell A2 are uppercase and lowercase.