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

Article translations Article translations
Article ID: 289577 - View products that this article applies to.
This article was previously published under Q289577
Expand all | Collapse all

On This Page

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: January 17, 2007 - Revision: 3.1
APPLIES TO
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
Keywords: 
kbexpertisebeginner kbhowtomaster KB289577

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com