Thursday, August 10, 2023

How to hide or show Paste Option in Excel?

 

When you apply Paste function in Excel, there will be a Paste Option icon doc-hide-paste-option-1 at the bottom right corner of the pasted range, sometimes you may think this Paste Option is so annoying. Now I tell you how to hide this Paste Option in Excel.

doc-hide-paste-option-2

Hide/turn off the Paste Option


arrow blue right bubble Hide/turn off the Paste Option

To hide or turn off the Paste Option, you need to go to Excel Options to set an option.

1. Click File or Office button > Options. See screenshot:

doc-hide-paste-option-3

2. Click Advanced in the left pane from the pop-up dialog, then scroll the right scrollbar to go to Cut, copy, and paste section, and uncheck Show Paste Optionsbutton when content is pasted. See screenshot:

doc-hide-paste-option-4

3. Click OK to close the dialog, then when data is pasted in Excel, the Paste Option will not be showed.

Tip: if you want to show the Paste Option again, just follow the above steps and check the Show Paste Options button when content is pasted option.

 https://www.extendoffice.com/documents/excel/1857-excel-hide-paste-option.html

No comments: