| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I turn off the automatic text suggestion in excel?
I am trying to write a macro to merge data in several cells into one with
dashes between. The automatic fill of text is messing this up. For example, if you have "public service" written in the same column and you go to write something else that starts with a "p" in automatically suggest the text. If that is the column being used for the macro merge of data then it leaves the suggested text with the way the macro is being written. If I can turn off this auto fill of text then my problem would be solved. Any suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I turn off the automatic text suggestion in excel?
If you go to the Office Button, Excel Options, Advanced Tab, and deselect the
check mark next to Enable Autocomplete for Cell Values. This should turn the autocomplete feature off for you. "CarolinaChickadee" wrote: I am trying to write a macro to merge data in several cells into one with dashes between. The automatic fill of text is messing this up. For example, if you have "public service" written in the same column and you go to write something else that starts with a "p" in automatically suggest the text. If that is the column being used for the macro merge of data then it leaves the suggested text with the way the macro is being written. If I can turn off this auto fill of text then my problem would be solved. Any suggestions? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I turn off the automatic text suggestion in excel?
Thank you. I don't know how I missed it!
"Brad Vogt" wrote: If you go to the Office Button, Excel Options, Advanced Tab, and deselect the check mark next to Enable Autocomplete for Cell Values. This should turn the autocomplete feature off for you. "CarolinaChickadee" wrote: I am trying to write a macro to merge data in several cells into one with dashes between. The automatic fill of text is messing this up. For example, if you have "public service" written in the same column and you go to write something else that starts with a "p" in automatically suggest the text. If that is the column being used for the macro merge of data then it leaves the suggested text with the way the macro is being written. If I can turn off this auto fill of text then my problem would be solved. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel: How do I turn off automatic e-mail if text has @ sign? | Excel Discussion (Misc queries) | |||
| How do I turn off automatic fill coloring in excel | Excel Discussion (Misc queries) | |||
| How do I turn off automatic fill coloring in excel | Excel Discussion (Misc queries) | |||
| How do you turn off automatic "save a copy" in Excel | Excel Discussion (Misc queries) | |||
| how do you turn off automatic hyperlink in excel 2003 | Excel Discussion (Misc queries) | |||
Hybrid Mode
