does excel have autotext function

  • Thread starter Thread starter meanieau
  • Start date Start date
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.
 
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
 
Please try using the Auto Correct feature.(Tools,Auto Correct, Replace :type
the abbreviation you want, With : Write the full name)
Anu
 

Ask a Question

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.

Ask a Question

Similar Threads

How do I use autotext in excel? 4
autotext from word to excel 1
How do I insert AutoText in an Excel worksheet? 2
Autotext in Excel 1
Word Autotext Word 2007 0
autotext 1
Convert 2002 Word Autotext into 2007 Word Auto Text 7
Where can Autotext be copied? 1

Back
Top