<div>
Are you talking about AutoComplete?
</div>


<div>
Roy, your link was a watershed of information. &nbsp;Now if I redesign a couple of spreadsheet I will make like easier for everyone. &nbsp;I believe this is the point!
</div>


Roy, your link was a watershed of information.  Now if I redesign a couple of spreadsheet I will make like easier for everyone.  I believe this is the point!

<div>
Glad it helped. It's surprising how many under used features that excel has.
</div>


Glad it helped. It's surprising how many under used features that excel has.

<div>
<div class="content wysiwyg-content">
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 &nbsp;and only text in cells directly above the cell you are entering new text. &nbsp;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.<br />
<br />
I have tried to research this feature but had little success. &nbsp;Anyone know the name of this feature?
</div>
</div>


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?

What is this Excel feature called? (I want to research it.)

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.