[Hide or display the Paste Options button

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Follow these steps to turn it on. Go to File > Options > Advanced. In the Cut, copy, and paste section, select Show Paste Options button when content is pasted. Hide or display the Paste Options button · Click the File tab, then click Options. · In the Advanced category, under Cut, copy, and paste, clear or select the.
 
 

Control the formatting when you paste text

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. 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.

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. 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. Under Authoring and Proofing Tools , click Edit. Under Authoring , click Edit. This article explains how to show or hide the Paste Options button on a PC. Click the File tab, then click Options. Need more help? Expand your skills. Get new features first. Was this information helpful?

Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow.

No jargon. Pictures helped. Didn’t match my screen. Incorrect instructions. Too technical. Not enough information. Not enough pictures. Any additional feedback? Submit feedback. Thank you for your feedback!

Paste Special – Microsoft Support – Was this information helpful?

 
Follow these steps to turn it on. Go to File > Options > Advanced. In the Cut, copy, and paste section, select Show Paste Options button when content is pasted. Hide or display the Paste Options button · Click the File tab, then click Options. · In the Advanced category, under Cut, copy, and paste, clear or select the.