How to turn off prediction in excel will be shared by Taimienphi.vn 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.
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.
Step 2: In Excel Options, You find the item Advanced.
Step 3: In Advanced, the item Editing options You unmark the item Enable AutoComplete for cell values. Done then press OK, got it.
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 Thuthuat.taimienphi.vn as Filter data between sheets in Excel .. help you be more productive at work. Good luck with your job.