Article ID: 289577 - View products that this article applies to.
This article was previously published under Q289577
After you perform a copy-and-paste operation in Microsoft Excel, the Paste Options button is displayed near the paste destination. This step-by-step article explains how to make the Paste Options button disappear and how to prevent options from appearing.
How to make the Paste Options button disappearThe Paste Options button is displayed until one of the following actions occurs:
Note These conditions also apply to the Auto Fill Options and the Insert Options that appear in Excel.
How to prevent options from appearingTo prevent the paste options, the auto fill options, and theinsert options from appearing, follow these steps, as appropriate for the version of Excel that you are running.
Microsoft Office Excel 2007
Microsoft Office Excel 2003 and earlier versions of Excel
For more information on Paste Options, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/280533/ )Paste Options button does not appear when you paste between two instances of Excel
(https://support.microsoft.com/kb/291358/ )How to use the Paste Options button in Excel
Article ID: 289577 - Last Review: January 17, 2007 - Revision: 3.1