AutoComplete

Enter the first few characters of a label entered above the current cell and Excel will complete the remainder of the cell contents if it finds a match. 

This feature is only available with labels (text) not values (numbers). This feature will not work if a blank cell is present between (above) the cell you are entering data into and the previous data.

Additional References