Hide or display the Paste Options button in Excel 2007

The Paste Options button is available when you paste data into the cells. By default, this button is displayed when you paste the data. You can change an Excel option and hide the Paste Options button. At any time, you can display or hide the Paste Options button. Perform the following steps to hide or display the Paste Options button:
1. Open Microsoft Excel.
2. Click the Microsoft Office Button and click Excel Options.
3. From the Excel Options dialog box, click Advanced from the left pane.
4. From the right pane, under Cut, copy, and paste. Do one of the following:

• To hide the Paste Options button - Click to remove the checkmark besides Show Paste Options buttons.
• To display the Paste Options button - Click to place the checkmark besides Show Paste Options buttons.

5. Click OK.


When you copy and paste data then by default the Paste Options button appears at the right bottom area of the destination cells. You can change this behavior and make Excel to hide or display the Paste Options button always. Perform the following steps to hide or display the Paste Options button:

Paste Options button not appearing in Excel 2007

When you copy data and paste it by pressing the CTRL + V keys or by clicking the Paste from the Home tab, you will see the Paste Options button at the lower right side of the destination cells. If you do not see the Paste Options button then these might be the reasons.
a. When pasting the data, you selected the destination cells and pressed the ENTER key instead of pressing CTRL + V or clicking Paste.
b. The Show Paste Options buttons option is not checked in the Excel Options. To place the checkmark, click the Microsoft Office button and click Excel Options. Click Advanced from the left pane. In the right pane, click to place a checkmark besides Show Paste Options buttons and click OK.