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.

Supported on: At least Windows 7

Registry HiveHKEY_CURRENT_USER
Registry Pathsoftware\policies\microsoft\office\16.0\common\toolbars\excel
Value Nameallowquickanalysis
Value TypeREG_DWORD
Enabled Value1
Disabled Value0

excel16.admx

Administrative Templates (Computers)

Administrative Templates (Users)