Policy

Show Insert Options buttons

This policy setting sets the "Show Insert Options buttons" option found under File tab | Options | Advanced | Cut, copy, and paste options. If you enable or do not configure this policy setting, Excel will show the Insert Options button after inserting cells, rows, or columns that contain formatting. This is the default behavior. If you disable this policy setting, Excel will not display the Insert Options buttons on insert.

Policy
Pack Microsoft Office
Category Microsoft Excel 2016 / Excel Options / Advanced
Policy ID e66bd21e9a90
Internal name L_ShowInsertOptionsbuttons

Registry

Copy registry mappings

HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions\enableinsertcellsooui_102_1 (enabled) = 0
HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions\enableinsertcellsooui_102_1 (disabled) = 1

Policy notes

This policy setting sets the "Show Insert Options buttons" option found under File tab | Options | Advanced | Cut, copy, and paste options. If you enable or do not configure this policy setting, Excel will show the Insert Options button after inserting cells, rows, or columns that contain formatting. This is the default behavior. If you disable this policy setting, Excel will not display the Insert Options buttons on insert.

Related policies

Alert before overwriting cellsAllow formatting and labels to track data pointsAlternate startup file locationAsk to update automatic linksAutomatically Flash FillAutomatically insert a decimal pointComments