Enable additional actions in Excel
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
| State | Value written |
|---|---|
| Enabled | REG_DWORD = 2 |
| Disabled | REG_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 DWordDisable
# 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 DWordRevert 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 SilentlyContinueApplication
Microsoft 365 Apps / Office (Microsoft) — November 2026 templates
Official templates downloaded on November 12, 2026.