XL7: Cell Format Causes Unexpected Behavior with AutoComplete

The information in this article applies to:

• Microsoft Excel for Windows 95, version 7.0

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.