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.

Tools | Options | Edit (tab)
Checkmark: "Enable AutoComplete for cell values"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"meanieau"
wrote in message
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.

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.

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.