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:
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:
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.
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:
0 comments:
Post a Comment