Auto complete text in a cell?

  • Thread starter Thread starter Lady18wheeler
  • Start date Start date
L

Lady18wheeler

How can I fix my spreadsheet so that when I type in the first letter(s)
of a word, the program automatically completes the word? Can I fix it
so it will give me a choice of words?

Specifically, I just hate to keep typing the same terminal name over
and over.

Thanks much
 
Hi

If you hate typing the same terminal name over and over, why not use a
two-letter abbreviation and then use Find/Replace to change all the
instances at the end?

Andy.
 
Andy B wrote:
If you hate typing the same terminal name over and over, why not use a
two-letter abbreviation and then use Find/Replace to change all the
instances at the end?
Click to expand...

Another way is to use
Tools >> AutoCorrect

Make up 2-character abbreviations and add them to the AutoCorrect list. I
use abbreviations that wouldn't appear naturally, like starting with a
comma; for example, ",e" for my email address.
 
Back
Top