You are currently offline, waiting for your internet to reconnect

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

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

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:
    • To turn off Paste Options and Auto Fill Options, click to clear the Show Paste Options buttons check box.
    • To turn off Insert Options, click to clear the Show Insert Options buttons check box.
  4. 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:
    • To turn off Paste Options and Auto Fill Options, click to clear the Show Paste Options buttons check box.
    • To turn off Insert Options, click to clear the Show Insert Options buttons check box.
REFERENCES

For more information on Paste Options, click the following article numbers to view the articles in the Microsoft Knowledge Base:
280533 Paste Options button does not appear when you paste between two instances of Excel
291358 How to use the Paste Options button in Excel
Properties

Article ID: 289577 - Last Review: 01/17/2007 00:35:09 - Revision: 3.1

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

  • kbexpertisebeginner kbhowtomaster KB289577
Feedback