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.
 

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

incorrect totals 2
Excel Vba to change displayed year automatically. 14
Making payments correspond to correct date 1
How to type each letter of the alphabet automatically in a specific color in Word? 0
Use word to associate an item in validation drop down list 2
vlookup tables 2
Date Formatting 6
Date Question 7

Back
Top