How to make Paste options disappear after you paste in Excel 2002 or in Excel 2003 (289577)

SUMMARY

After you perform a copy and paste operation in Microsoft Excel 2002 or in Microsoft Office Excel 2003, the Paste options are displayed near the paste destination. This step-by-step article explains how to make the Paste Options disappear or prevent them from appearing.

back to the top

Make Paste Options Disappear

The Paste Options are displayed until one of the following four actions occur:

• You perform an action that can be undone, other than those listed in the Paste Options.
• 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 cancel the Paste Options.

NOTE: These conditions also apply to the Auto Fill Options and the Insert Options that appear in Excel 2002 and in Excel 2003.

An action that can be undone is an action that is added to the undo stack. When you click the arrow next to the Undo button on the Standard toolbar, you see the list of actions that can be undone.

back to the top

Prevent Options from Appearing

To turn off Paste Options, Auto Fill Options, and Insert Options, follow these steps:

1. On the Tools menu, click Options.
2. Click the Edit tab.
3. To turn off Paste Options and Auto Fill Options, click to clear the Show Paste Options buttons check box.
4. To turn off Insert Options, click to clear the Show Insert Options buttons check box.

back to the top