Using the AutoComplete feature

AutoComplete is a feature that is used to display a list of texts that have been put in the cell that is active. List of text will be displayed when entering new data if no initial letters (not necessarily 1 letter) with the same text that was typed in the active cell.

1. Create a new workbook (press Ctrl + N) and create data in the range A1: A3 as the example image below.

 
2. If you type P in cell A4 the AutoComplete feature will automatically display the man because the initial letters beginning with the letter P same Pria who had entered in cell A1.

 
3. Press the Enter key when the data you enter is the man. If the data you entered is not a man, then continue typing the data as usual.

AutoComplete feature is very helpful when entering many of the same data in a single column. However, there are some users who just do not like this feature because it makes the display AutoComplete sometimes we do not focus on entering data.

• Click the Office Button and then press the button Excel Options. Excel Options dialog box appears.

 

• Select the Advanced option. Remove the tick mark (√) the option Enable AutoComplete for cell values ​​and then press OK.
• To try it, type P in cell A4. If the man does not appear in the text cell A4, then was off in the AutoComplete feature.