Microsoft KB Archive/134351

= Cell Format Causes Unexpected Behavior with AutoComplete =

Article ID: 134351

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition

-



This article was previously published under Q134351





SYMPTOMS
When you use the AutoComplete feature in Microsoft Excel, you may not receive the results you expect if you are working with cells that have different formats.



CAUSE
Microsoft Excel uses automatic header detection; so, if the first cell in a column is formatted with a color, for example, Microsoft Excel will interpret the value in that cell as header, and the entry will not be included as part of the AutoComplete list.



STATUS
This behavior is by design.



MORE INFORMATION
When you type the first few letters of an entry in a cell, Microsoft Excel can complete the entry for you based on the entries you've made in that column. To see a list of possible cell entries, click a cell using the right mouse button, and then click Pick From List. Microsoft Excel automatically creates a list from the words you've typed in the column.

Additional query words: auto complete formatting style XL7

Keywords: KB134351

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.