Microsoft Excel 2010: Disable Cell AutoComplete

Have you ever developed exhausted of Microsoft Excel 2010 “suggesting” what to go in in a cell founded on what you have went into into preceding cells? This is called autocompleting, a characteristic that may save you time if you often re-enter the identical facts and numbers into distinct cells.

1. Select the “File” tab in the Ribbon.

2. The Microsoft Office Backstage View appears. Click the “Options” button.

3. The “Excel Options” dialog carton appears. Click “Advanced” in the left pane.

4. Underneath “Editing options”, uncheck “Enable AutoComplete for cell values”.

5. Click “OK” on the bottom-right of the dialog carton to close it.