Policy

Show Paste Options button when content is pasted

This policy setting sets the "Show Paste Options button when content is pasted" 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 Paste 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 Paste Options buttons on paste.

Policy
Pack Microsoft Office
Category Microsoft Excel 2016 / Excel Options / Advanced
Policy ID 6fc6f5225132
Internal name L_ShowPasteOptionsButtonWhenContentIsPasted

Registry

Copy registry mappings

HKCU\software\policies\microsoft\office\16.0\common\general\pasteoptions (enabled) = 1
HKCU\software\policies\microsoft\office\16.0\common\general\pasteoptions (disabled) = 0

Policy notes

This policy setting sets the "Show Paste Options button when content is pasted" 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 Paste 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 Paste Options buttons on paste.

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