| Home |
| Search |
| Today's Posts |
|
#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? |
| 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) | |||
Threaded Mode
