Is there an "auto text" feature like that in Word?

  • Thread starter Thread starter Carms
  • Start date Start date
C

Carms

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?
 
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
 
No there is no "AutoText" feature in Excel. I guess the reasoning is that
Excel is more of a number cruncher and not a word processor.

Data Validation ensures the user enters clean data and autocomplete only
works if previous data in the same column is present.
 
Back
Top