does excel have autotext function

M

meanieau

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.
 
J

Jim Cone

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.
 
G

Gord Dibben

No.

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


Gord Dibben MS Excel MVP
 
A

Anu

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