Show Insert Options buttons

Supported on: At least Windows Server 2008 R2 or Windows 7

Registry

HKCU software\policies\microsoft\office\16.0\excel\options\binaryoptions

Value name: enableinsertcellsooui_102_1

Enabled: enableinsertcellsooui_102_1 = 0

Disabled: enableinsertcellsooui_102_1 = 1

Description

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.