Policy

Show Quick Analysis options on selection

This policy setting controls the "Show Quick Analysis options on selection" option found under File tab | Options | General | User Interface Options. If you enable or do not configure this policy setting, Excel will show Quick Analysis options when data is selected. This is the default behavior. If you disable this policy setting, Excel will not show these options on selection.

Policy
PackMicrosoft Office
CategoryMicrosoft Excel 2016 / Excel Options / General
Policy ID0d5f045fa532
Internal nameL_AllowQuickAnalysis

Registry

Copy registry mappings

HKCU\software\policies\microsoft\office\16.0\common\toolbars\excel\allowquickanalysis (enabled) = 1
HKCU\software\policies\microsoft\office\16.0\common\toolbars\excel\allowquickanalysis (disabled) = 0

Policy notes

This policy setting controls the "Show Quick Analysis options on selection" option found under File tab | Options | General | User Interface Options. If you enable or do not configure this policy setting, Excel will show Quick Analysis options when data is selected. This is the default behavior. If you disable this policy setting, Excel will not show these options on selection.

Related policies

Default FontDefault SheetsEnable Live PreviewShow all windows in the TaskbarShow Mini Toolbar on selection