Microsoft KB Archive/289577

= How to make Paste Options button disappear after you paste in Excel =

Article ID: 289577

Article Last Modified on 1/17/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q289577





SUMMARY
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 disappear
The Paste Options button is displayed until one of the following actions occurs:
 * You perform an action that can be undone. This action differs from those that are listed in the Paste Options list.

Note An action that can be undone is an action that is added to the undo stack. When you click the Undo button, you see the list of actions that can be undone.
 * The Clipboard contents change because you copy information in another Microsoft Office program.
 * You use the Undo command.
 * You type something in the worksheet or document.

In some situations, you can also press ESC to make the Paste Options button disappear.

Note These conditions also apply to the Auto Fill Options and the Insert Options that appear in Excel.

How to prevent options from appearing
To 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

 * 1) Click the Microsoft Office Button, and then click Excel Options.
 * 2) Click Advanced.
 * 3) Under Cut, copy, and paste, use one or both of the following procedures:
 * 4) * To turn off Paste Options and Auto Fill Options, click to clear the Show Paste Options buttons check box.
 * 5) * To turn off Insert Options, click to clear the Show Insert Options buttons check box.
 * 6) Click OK.

Microsoft Office Excel 2003 and earlier versions of Excel

 * 1) On the Tools menu, click Options.
 * 2) Click the Edit tab.
 * 3) Use one or both of the following procedures:
 * 4) * To turn off Paste Options and Auto Fill Options, click to clear the Show Paste Options buttons check box.
 * 5) * To turn off Insert Options, click to clear the Show Insert Options buttons check box.

