Why is the Follow button grayed out

Paste Options button hidden after pasting in Excel

  • 2 minutes to read
  • Applies to:
    Microsoft Office Excel 2007, Microsoft Office Excel 2003

Note

Office 365 ProPlus is in Microsoft 365 apps for business renamed. Please see this blog post for more information on this change.

Summary

After doing a copy and paste operation in Microsoft Excel, you will see the Paste Options button near the paste destination. This step-by-step article explains how to make the Paste Options button disappear and prevent options from appearing.

Here's how to make the Paste Options button disappear

The Insert Options button appears until one of the following occurs:

  • You are performing an action that can be undone. This action is different from what is shown in the Paste Options list.

    Note

    An action that can be undone is one that is added to the undo stack. Clicking the Undo button displays the list of actions that can be undone.

  • The contents of the clipboard will change as you copy information to another Microsoft Office.

  • Use the Undo command.

  • You enter something in the worksheet or document.

In some situations, you can also press esC to remove the Paste Options button.

Note

These conditions also apply to the auto-fill options and the paste options shown in Excel.

How to prevent options from appearing

To prevent the paste options, auto-fill options, and paste options from appearing, do the following if necessary for the version of Excel you are running.

Microsoft Office Excel 2007

  1. click on Microsoft Office button, and then click Excel options.
  2. click on Extended.
  3. Use Under cut, copy and paste one or both of the following:
    • To turn off paste options and auto-fill options, click to clear the check box Paste options disable ads.
    • To turn off paste options, click to clear the check box Paste options disable ads.
  4. click on OK.

Microsoft Office Excel 2003 and earlier versions of Excel

  1. On the Tools menu, click Options.
  2. Click the Edit tab.
  3. Do one or both of the following:
    • To turn off paste options and auto-fill options, click to clear the check box Paste options disable ads.
    • To turn off paste options, click to clear the check box Paste options disable ads.

Sources of information

For more information about paste options, see Using the Paste Options Button in Excel.

Is this page helpful?