Quick Question

[mahmed1]

Hi Guys,

If i have typed a name before in Row A1 (say Mark) and i try to input the name Mark again in Cell A2, It automatically used to pull through Mark and i could i either keep press enter or overtype unless the name was other than Mark....

For some reason this is not working. How can i have the otion to have this but also not have this (Just for reference)

Thank You

 

[VoG]

Perhaps this http://www.microsofttraining.net/tip-466-disable-excel-autocomplete-feature.html

 

[Smitty]

You might have disabled AutoComplete.

In Excel 2007+ goto Office/File-->Options-->Advanced-->Editing Options-->Enable AutoComplete. In earlier versions it'll be under Tools-->Options.

HTH,

 

[mahmed1]

You might have disabled AutoComplete.

In Excel 2007+ goto Office/File-->Options-->Advanced-->Editing Options-->Enable AutoComplete. In earlier versions it'll be under Tools-->Options.

HTH,

Perhaps this http://www.microsofttraining.net/tip-466-disable-excel-autocomplete-feature.html

Thank You Both