AutoComplete may not work

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article was previously published under Q211652
For a Microsoft Excel 97 version of this article, see 174444.
You type text in a cell in Microsoft Excel. The first few characters of the text that youtype match an existing entry in that column. When this occurs, the AutoComplete feature maynot automatically fill in the remaining characters.
In Microsoft Excel, the AutoComplete feature may not fill in the remaining characters if the algorithm that Excel uses detects a header row in the list.


When you use the steps in the following example, the AutoComplete featuredoes not appear to function properly.
  1. Save and close any open workbooks, and then create a new workbook.
  2. In cell A1, type 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, type 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 incell A2 are all lowercase, Microsoft Excel determines that row 1 is a listheader row. The algorithm for the AutoComplete feature does not generatesuggested text if the first row is considered a list header row. Thisbehavior also occurs if characters in cell A2 are uppercase and lowercase.
auto complete autocorrect XL2000 XL2003 XL2007

Article ID: 211652 - Last Review: 01/23/2007 22:19:33 - Revision: 4.2

Microsoft Office Excel 2007, Microsoft Office Excel 2003, Microsoft Excel 2002 Standard Edition, Microsoft Excel 2000 Standard Edition

  • kbprb kbui KB211652