| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there an "auto text" feature like that in Word?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I auto transform sets of data? (change "female" to "f") | Excel Discussion (Misc queries) | |||
| text string: "91E10" in csv file auto converts to: "9.10E+11" | Excel Discussion (Misc queries) | |||
| Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
| XL2003: "Auto row height" with Wrap Text driving me nuts | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Hybrid Mode
