Is there an "auto text" feature like that in Word?
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.
"JP" wrote:
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?
|