I assume you mean that you want AutoComplete. Go to Tools, Options, Edit and
select the box at the bottom: Enable AutoComplete for Cell Values.
To set up things to replace (for example I have my version replacing my
initials with my name), go to Tools, AutoCorrect Options and set things up in
there.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.