Cell Format Causes Unexpected Behavior with AutoComplete (134351)
The information in this article applies to:
- Microsoft Excel for Windows 95
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.
| Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
|---|
| Keywords: | KB134351 |
|---|
|