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

Turn Off automatic parsing of data in Excel 1
How do I turn off Text to Columns 2
Excel 2003 -turn off the text speech 1
How to remove text edit from Autoshapes 4
How do I remove the annoying automatic date formatting in Excel? 1
Getting Text data using the Data - Subtotal feature 1
How do I automate bracketing of text in an Excel cell? 1
How do I turn off the automatic Format Painter? 2

Top