Article ID: 263552 - View products that this article applies to.
This article was previously published under Q263552
This step-by-step article describes how to turn the AutoComplete feature on or off. (The AutoComplete feature automatically completes entries in columns.)
This information is also covered in more detail in Microsoft Excel 2000 Help. For more information about how to view this information in Help, please see the REFERENCES section later in this article.
If the first few characters that you type in a cell match an existing entry in that column, Microsoft Excel fills in the remaining characters for you. Microsoft Excel completes only those entries that contain text or a combination of text and numbers; entries that contain only numbers, dates, or times are not completed.
For more information about AutoComplete, click Microsoft Excel Help on the Help menu, type autocomplete in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.