XL7: Cell Format Causes Unexpected Behavior with AutoComplete

• 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.

Additional query words: auto complete formatting style

Keywords          : xlwin 
Version           : 7.00
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: July 29, 1999