Hints and tips home » Excel hints and tips » Turn off AutoComplete in Excel

Turn off AutoComplete in Excel

You may have noticed when typing into your spreadsheets that if you start to enter labels that begin with the same letters as a label that has been previously entered in the same spreadsheet, Excel will try and automatically complete the text for you. This feature is called AutoComplete.

If you find this feature more annoying than useful, you can turn it off by:

1. Going to Tools - Options.

2. Select the Edit tab.

3. Remove the tick from next to the "Enable AutoComplete for cell values" option.

4. Click OK.

Added by Amanda on 26th November 2006

More Excel hints and tips, like:

• Sum Up All the Values in A Column
• Moving between Worksheets without using the mouse
• Cycling through Absoulte cell references