Turn off turn on the character repeat function in Excel

In Excel, when you enter content into a cell and then you enter the content below that cell with the same characters as the first character of the cell content above. The content of the above box will be suggested to display in the lower box, this sometimes makes you feel very annoying.

You want to turn off the repeat function but do not know how to do it?

Turn off turn on the character repeat function in Excel Picture 1

The following article will guide you how to turn off the reminder function when typing text characters in Excel.

Step 1: Open the Excel file to disable, select File -> Options .

Turn off turn on the character repeat function in Excel Picture 2

Step 2: In the Excel Options dialog box, select the Advanced tab .

Turn off turn on the character repeat function in Excel Picture 3

Step 3: In the Editing options section, deselect the Enable AutoComplete for cell values box, then click OK .

Turn off turn on the character repeat function in Excel Picture 4

Thus, the repeat function has been turned off, to turn it back on you just need to do the same and check the box Enable AutoComplete for cell values .

Good luck!

Isabella Humphrey

Update 19 May 2020

You should read it

May be interested

How to count the number of occurrences of a character in Excel
counting the number of occurrences of a character in excel is a trick that requires you to use a combination of two different functions. to know how to combine this function, please follow the following article of tipsmake.com us.
How to turn off content suggestions on Excel
when you enter content in excel, the system will save the content and make suggestions for other content, if the first character is the same. so how to turn off input suggestions in excel?
How to use COUNTIF function on Excel
the countif function on excel is the cell count function to satisfy the given condition, often used in statistics tables.
How to use the MOD function and QUOTIENT function in Excel
injury in excel has many ways of doing it, can be used manually or using the calculation function.
8 little-known Excel functions that can save you a lot of work
even seasoned excel users often find themselves stuck performing tasks manually that could be automated with a few clever functions.
How to use Excel's VALUE function
excel's value function will convert a string to a digital form, which can be combined with other functions such as left function, right function, mid function.
Do not round numbers in Excel, turn off rounding in Excel
rounding numbers in excel is a handy function for calculating data, but sometimes it also makes you feel unnecessary troubles. to turn off the function of rounding in excel you can follow the following instructions
How to use the WRAPROWS function in Excel
having trouble with handling large data sets in excel? then learn how to use the wraprows function to split them into more manageable rows.
How to use the IFS function in Excel 2016
the ifs function in excel is a logical function introduced in excel 2016. this function is a function that replaces the nested if function and is much easier to use. the ifs function checks one or more conditions and returns a value that meets the first true condition.
How to use the NPER function in Excel to plan loans and savings
do you want to effectively manage and control your personal finances? then we invite you to learn how to use excel's nper function.

Turn off turn on the character repeat function in Excel

You should read it

May be interested

Office information