Open in the explorer

Enable additional actions in Excel

Type
User
GPO path
User Configuration › Policies › Administrative Templates › Microsoft Office 2016 › Tools | AutoCorrect Options... (Excel, PowerPoint and Access) › Additional Actions
Supported on
At least Windows Server 2008 R2 or Windows 7
ADMX file
office16.admx
Internal name
office16/L_EnableAdditionalActionsInExcel

Explanation

This policy setting controls whether Excel can provide additional actions for certain words and phrases in a workbook through the right-click menu, and whether users can configure this behavior by checking or unchecking the "Enable additional actions in the right-click menu" option under the File tab | Options | Proofing | AutoCorrect Options | Actions tab. If additional actions functionality is turned on, Excel can recognize dates and financial symbols and provide additional actions for them.

If you enable or do not configure this policy setting, users can configure Excel to provide additional actions. Note: Excel does not provide additional actions until users check the "Enable additional actions in the right-click menu" option in the UI.

If you disable this policy setting, users cannot configure Excel to provide additional actions.

Registry

HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\options
Value name
recognizesmarttags
StateValue written
EnabledREG_DWORD = 2
DisabledREG_DWORD = 0

PowerShell

PowerShell commands that write to the registry what the policy would write. Values in angle brackets (<…>) must be replaced.

Writing directly to the registry bypasses Group Policy: if a GPO manages this value, it will be rewritten at the next gpupdate; otherwise the value stays in place (the "tattooing" effect). Prefer a GPO or, locally, LGPO.exe. Run PowerShell as administrator for HKLM. Some policies need a restart or gpupdate /force.

Enable

# Enable: office16/L_EnableAdditionalActionsInExcel
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\options'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
Set-ItemProperty -Path $k -Name 'recognizesmarttags' -Value 2 -Type DWord

Disable

# Disable: office16/L_EnableAdditionalActionsInExcel
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\options'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
Set-ItemProperty -Path $k -Name 'recognizesmarttags' -Value 0 -Type DWord

Revert to "Not configured"

# Revert to "Not configured": office16/L_EnableAdditionalActionsInExcel
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\options'
Remove-ItemProperty -Path $k -Name 'recognizesmarttags' -ErrorAction SilentlyContinue

Application

Microsoft 365 Apps / Office (Microsoft) — November 2026 templates

Official templates downloaded on November 12, 2026.