Hide or display the Paste Options button - Help and How-to

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Printer-Friendly Version

Hide or display the Paste Options button

Applies to: Microsoft Office Excel 2003

By default, Excel displays a Paste Options button on the worksheet to provide you with special options, such as Keep Source Formatting and Match Destination Formatting, when you paste cells. If you don't want to display this button every time you paste cells, you can turn this option off.

On the Tools menu, click Options.
On the Edit tab, clear or select the Show Paste Options buttons check box to hide or display the Show Paste Options button on the worksheet.