Excel Autocomplete

[clayton74]

Is there a way of enabling auto-complete to complete anywhere in the excel sheet
If I put hello in cell A1 I want to be able to autocomplete when I begin typing in cell C9

Any help would be appreciated

 

[SkipVought]

Clayton,

Excel is a spreadsheet application. As such, it has functionality that lends itself to spreadsheets.

Spreadsheets are tabular formats. Column A might be Names and column D might be Cities. I sure like it when Excel recognizes a name I entered previously and auto completes it. But if I were entering a city and started...
[tt]
cla
[/tt]
I would NOT want to see Clayton. I'd want to see a CITY like Claymore. It just how tables and spreadsheets are designed to work. What you are suggesting would be VERY CONFUSING and DISTURBING.

Skip,

_[red][/red]