Please try using the Auto Correct feature.(Tools,Auto Correct, Replace :type
the abbreviation you want, With : Write the full name)
Anu

"Gord Dibben" wrote:

No.

Autocomplete works in same column but not in non-contiguous ranges or across
sheets.


Gord Dibben MS Excel MVP

On Sun, 25 Nov 2007 21:15:02 -0800, meanieau
wrote:

Im trying to find a way for excel to permanently remember words through out
the whole workbook with out having to do it over and over on each page, like
the autotext function in Word.