autocomplete excel
Author
Discussion

rich 36

Original Poster:

13,739 posts

297 months

Thursday 5th July 2007
quotequote all
Where abouts is it please

TheGroover

1,044 posts

306 months

Thursday 5th July 2007
quotequote all
Tools > Options > Edit > Enable Autocomplete for cell values? Is that the one you mean?

rich 36

Original Poster:

13,739 posts

297 months

Thursday 5th July 2007
quotequote all
No,
whatever its called,

You type 'piston'
It predicts the rest and adds 'heads'

Roy the Boy

471 posts

252 months

Thursday 5th July 2007
quotequote all
TheGroover said:
Tools > Options > Edit > Enable Autocomplete for cell values? Is that the one you mean?
I reckon you should check you have this option ticked as it's the answer.

rich 36

Original Poster:

13,739 posts

297 months

Thursday 5th July 2007
quotequote all
I'll take another look in the morning,

Thanks

rich 36

Original Poster:

13,739 posts

297 months

Friday 6th July 2007
quotequote all
It is enabled, how do initiate say
'Pistonh...
To predict it and. Add 'heads' after?

LordGrover

34,189 posts

243 months

Friday 6th July 2007
quotequote all
I think you may be referring to AutoCorrect feature. Excel 2007 it's found under proofing.

Jinx

12,023 posts

291 months

Friday 6th July 2007
quotequote all
If an entry already appears in a cell in the column above then excel will complete the rest of the entry (after a unique set of characters has been entered) (its in tools > options > edit. Other than this if the entries have a list structure you can create a custom list in the tools > options > custom lists.

GhostyDog

464 posts

238 months

Friday 6th July 2007
quotequote all
What version of excel, like has been said before can you clarify between autocomplete and autocorrect.

Autocomplete is a feature provided by many source code text editors, word processors, and web browsers. Autocomplete involves the program predicting a word or phrase that the user wants to type in without the user actually typing it in completely. ...

Autocorrect in Microsoft office is a database of common mispellings and abbreviations that you can add to, it only works once the word or abbrev. has been completed by pressing the space bar or exiting a cell.

Which do you want?