Tuesday, February 23, 2010

Turn off AutoComplete in Excel 2010

Using AutoComplete, you speed up the operation of entering data in the cells and with error free. If you feel this feature has little use and decide to turn off this feature then you can do it by performing the following steps:
1. Open Microsoft Excel.
2. Click File menu and click Options to open Excel Options dialog box.
3. From the left pane, click Advanced.
4. From the right pane, in the Editing options section, click to remove the checkmark beside Enable AutoComplete for cell values.
5. Click OK.
/* */