By default, Excel and Word display a Paste Options button on the worksheet or document to provide you with special options, such as Keep Source Formatting, when you paste content. If you don't want to see this button every time that you paste content, you can turn this option off.
This article explains how to show or hide the Paste Options button on a PC.
Click the File tab, then click Options.
Note: If you are using Excel 2007, click the Microsoft Office Button , and then click Excel Options or Word Options.
In the Advanced category, under Cut, copy, and paste, clear or select the Show Paste Options button when content is pasted check box to hide or display the Show Paste Options button.
Note: If you are using Excel 2007, the check box is titled Show Paste Options buttons
When you paste content from one location to another, Word and Excel display a button that lets you choose different pasting options, such as keeping source formatting.
Paste Options button
If you don’t want to see this button, you can turn the option off.
Tip: To dismiss the button without hiding it permanently, press ESC or start typing.
Note: Some of the content in this topic may not be applicable to some languages.
On the Word menu, click Preferences.
Under Authoring and Proofing Tools, click Edit .
Under Cut and Paste Options, clear or select the Show Paste Options buttons check box.
On the Excel menu, click Preferences.
Under Authoring, click Edit .
Under Cut and Paste Options, clear or select the Show Paste Options check box.