Repeating Item Has Entered on Same Column

If you load the data down in a column, then the same data item when it will re-type Excel will equip you with the facility of typing autocomplete. This is done when your data in the form of text or a mixture of text and numbers, while the data in the form of numbers, the data is a date or time will not be enforced.


To accept the AutoComplete press the ENTER key, but if the text to be typed is not entirely the same, just continue typing what you want or press the Backspace button to cancel and then continue typing Autocomplete data.


Turn off AutoComplete Facilities

To disable the AutoComplete do the following:

1. Click the Microsoft Office button and then click Excel Options.
2. On the Advanced disable the option Enable AutoComplete for Cell values.