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
PackMicrosoft Office
CategoryMicrosoft Excel 2016 / Excel Options / Advanced
Policy IDe66bd21e9a90
Internal nameL_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