View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JP[_4_] JP[_4_] is offline
external usenet poster
 
Posts: 897
Default Is there an "auto text" feature like that in Word?

I think you mean either Data Validation (where you have an in-cell
dropdown with a predetermined list of entries) or Tools Edit
"Enable AutoComplete for cell values", which "Completes text entries
you start to type in a column of data. If the first few letters you
type match an existing entry in that column, Excel fills in the
remaining text for you." (from Excel help)

--JP

On Oct 9, 1:32*pm, Carms wrote:
In Word, one can type in 'Dec' with the program automatically recognizing the
user wants to type 'December.' Typing in 'dec' and hitting enter will
automatically enter 'December' for you. Is there a similar feature in Excel?