Over the years I have became aware that when you type in text is a test cell, similar text form other cells will flood the cell allowing to you to quickly reuse the same text. After enough testing I have deduced that it only works with text and only text in cells directly above the cell you are entering new text. The ascending cells must be the same size as the entry cell and Excel only utilizes data in ascending cells containing text and then only ascending to cells containing text that are contiguous to the cell in which you are entering new data.
I have tried to research this feature but had little success. Anyone know the name of this feature?