How do I turn off the automatic text suggestion in excel?

C

CarolinaChickadee

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?
 
B

Brad Vogt

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.
 
C

CarolinaChickadee

Thank you. I don't know how I missed it!

Brad Vogt said:
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.
Click to expand...
 

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

How do I turn off annotating with ink in Excel 2016 2
How do you turn off automatic bulleting in PP 2007? 1
Turn Off automatic parsing of data in Excel 1
Turn automatic Calc: off, script? 0
How do I turn off Autofit 2
Getting Text data using the Data - Subtotal feature 1
How to remove text edit from Autoshapes 4
How do I turn off what appears to be a stuck control key? 1

Top