How to turn off prediction in Excel, turn off suggestions in excel 2016, 2010, 2003

How to turn off prediction in excel will be shared by in this article. Although the phone is very useful when using Excel, many people are annoyed by this feature.

The predictive feature is one of the more useful features of Excel, but it sometimes brings a lot of troubles to users, especially for Vietnamese users. For example, when entering the name table, you enter the box above is Diep Van A, in the box below you enter is Dang Thi B.

How to turn off prediction in Excel 2010, 2007, 2003

But when you enter the D character, Excel will predict Diệp Văn A, you will have to delete the end … i Văn Văn A, or type D once, you will get DĐ Thị Thị B. It will take you a while to edit the data you have just entered, so turning off prediction in Excel is now essential.

How to call it in Excel

Instructions on how to turn off prediction in Excel

To turn off prediction in Excel, follow the instructions below:

Step 1: Click on it Office Button(with Office 2007) or File(in other versions of Office) and select Excel Options.

How to input data in Excel

Step 2: In Excel Options, You find the item Advanced.

How to make mistakes in excel

Step 3: In Advanced, the item Editing options You unmark the item Enable AutoComplete for cell values. Done then press OK, got it.

How to list this call in Excel

As such, the suggestion off feature in Excel makes it easy to enter your content without having to worry about correcting common errors when predicting is turned on. After entering data, you can re-enable the prediction by repeating steps 1 and 2, and then tick the item again Enable AutoComplete for cell values.
Above is an article on how to turn off prediction in Excel, you can also add references to other Excel tricks at as Filter data between sheets in Excel .. help you be more productive at work. Good luck with your job.


Add a Comment

Your email address will not be published. Required fields are marked *