Enable AutoComplete for cell values

This policy setting sets the "Enable AutoComplete for cell values" option found under File tab | Options | Advanced | Editing Options.

If you enable or do not configure this policy setting, Excel will allow AutoComplete for cell values. This is the default behavior.

If you disable this policy setting, Excel will turn off the AutoComplete feature.

Supported on: At least Windows 7

Registry Hive	HKEY_CURRENT_USER
Registry Path	software\policies\microsoft\office\15.0\excel\options\binaryoptions
Value Name	fautocomplete_128_1
Value Type	REG_DWORD
Enabled Value	1
Disabled Value	0

excel15.admx

Administrative Templates (Computers)

Microsoft InfoPath 2013 (Machine)
- Security
Microsoft Lync 2013
- Microsoft Lync Feature Policies
Microsoft Office 2013 (Machine)
Microsoft PowerPoint 2013 (Machine)
- Converters
  - Turn on an external converter as the default for a file extension

Administrative Templates (Users)

Microsoft Access 2013
- Application Settings
- Customizable Error Messages
  - List of error messages to customize
- Disable Items in User Interface
  - Custom
    - Disable commands
    - Disable shortcut keys
  - Predefined
    - Disable commands
    - Disable shortcut keys
- Miscellaneous
- Tools | Security
  - Workgroup Administrator...
    - Path to shared Workgroup information file for secured MDB files
  - Modal Trust Decision Only
Microsoft Excel 2013
Microsoft InfoPath 2013
Microsoft Lync 2013
- Microsoft Lync Feature Policies
Microsoft Office 2013
Microsoft OneNote 2013
- OneNote Options
Microsoft Outlook 2013
Microsoft PowerPoint 2013
Microsoft Project 2013
- Miscellaneous
- Project Options
  - Calculation
    - Calculation options for 'Project1'
    - Calculation options for Microsoft Project
      - Automatic Calculation
      - Calculate all open projects
  - Calendar
  - Customize Ribbon
    - Display Developer tab in the Ribbon
  - Edit
    - Edit options for Microsoft Project
    - Hyperlink appearance in 'Project1'
    - View options for time units in 'Project1'
      - Add space before label
      - Days
      - Hours
      - Minutes
      - Months
      - Weeks
      - Years
  - General
    - General options for 'Project1'
    - General options for Microsoft Project
    - Undo Levels
  - Interface
    - Project Guide settings for 'Project1'
      - Project Guide Content
      - Project Guide Functionality and Layout page
    - Project Guide settings
      - Display Project Guide
    - Show indicators and Option butons for
    - Disable Internal ID Matching
  - Save
    - Auto Save Options
    - File locations
      - Projects
      - User Templates
    - Tools | Local Project Cache
      - Local Project Cache Location
      - Local Project Cache Size Limit in MB
    - Save Microsoft Project files as
  - Schedule
    - Schedule options for Microsoft Project
      - Show assignment units as
      - Show scheduling messages
    - Scheduling options for 'Project1'
  - Security
  - View
    - Calendar Type
      - Calendar Type
    - Show
    - Date Format
    - Default Project Currency
    - Default View
    - Project Summary Task
Microsoft Publisher 2013
Microsoft SharePoint Designer 2013
- Default Authoring Options
- Disable Items in User Interface
  - Custom
    - Disable commands
  - Predefined
    - Disable commands
- Downloading Framework Components
  - Hide missing component download hyperlinks
  - Set download location for Microsoft .NET Framework 4
Microsoft Visio 2013
- Customizable Error Messages
  - List of error messages to customize
- Disable Items in User Interface
  - Custom
    - Disable commands
    - Disable shortcut keys
  - Predefined
    - Disable commands
- Miscellaneous
- Visio Options
  - Advanced
  - Customize Ribbon
    - Display Developer tab in the Ribbon
  - General
    - User Interface Options
  - Proofing
    - AutoCorrect Options
  - Save
    - Offline Editing
      - Save checked-out files to
    - Save Documents
      - Prompt for document properties on first save
      - Save Visio files as
    - Turn off CAD/DWG functionality
  - Security
    - Macro Security
      - Enable Microsoft Visual Basic for Applications project creation
      - Load Microsoft Visual Basic for Applications projects from text
    - Trust Center
Microsoft Word 2013