Excel shows a button when you paste data into the spreadsheet. It helps you customize the data as per your requirements. For example, you can continue using the source format, paste the data in a special way, etc. However, if you do not want such options and want to get rid of this annoying option, this guide will help you for sure.
How to remove Paste Options button after pasting in Excel
To hide Paste Options button after pasting in Excel, follow these steps: To learn more about these steps, continue reading. First, you need to open Microsoft Excel on your computer and click on the File menu in the top menu bar. Then, select Options visible in the bottom-left corner to open the Excel Options panel. Next, switch to the Advanced tab and find the Show Paste Options when content is pasted checkbox.
Remove the tick from the corresponding checkbox and click the OK button to save the change. That’s all! After that, you cannot find the Paste Options button after pasting data in any spreadsheet.
How to hide Paste Options button after pasting in Excel using Registry
To remove Paste Options button after pasting in Excel using Registry, follow these steps: Let’s check out these steps in detail. To get started, you need to open the Registry Editor. For that, you can search for regedit or registry editor in the Taskbar search box and click the individual search result. Then, click on the Yes button on the UAC prompt. Once it is opened, navigate to the following path: There is a chance that you may not find the office key. In that case, right-click on Microsoft > New > Key, and name it as office. Next, repeat the same steps to create other sub-keys. Once the common key is created, right-click on it, select New > Key, and name it as general.
Then, you need to create a REG_DWORD value. For that, right-click on general > New > DWORD (32-bit) Value and set the name as pasteoptions.
As you want to hide the Paste Options button, you need to keep the Value data as 0. Finally, restart your computer. However, if you want to revert the change, you have two options. First, you can delete the pasteoptions value. Second, you can set the Value data as 1. For that, double-click on pasteoptions, enter 1 as the Value data, click the OK button, and restart your computer.
How to hide Paste Options button after pasting in Excel using Group Policy
To hide Paste Options button after pasting in Excel using Group Policy, follow these steps: Let’s learn more about the above-mentioned steps in detail. First, press Win+R > type gpedit.msc > press the Enter button to open the Local Group Policy Editor on your computer. Next, navigate to this path: Double-click on the Show Paste Options button when content is paste setting and choose the Disabled option.
Next, click the OK button and restart Microsoft Excel if it was opened during the change.
How do I make Paste Options go away?
To make the Paste Options go away in Excel, you need to follow the above-mentioned steps. Open Excel, click on File > Options, go to the Advanced tab and find the Show Paste Options button when content is pasted checkbox. Then, remove the tick from the checkbox and click the OK button. Alternatively, you can use the Group Policy and Registry methods as well.
How do I get rid of the autofill options box in Excel?
To get rid of the autofill options box in Excel, you need to open Excel Options first. Then, switch to the Advanced tab and find the Enable fill handle and cell drag-and-drop setting. Remove the tick from the checkbox and click the OK button. That’s all! Hope this guide helped. Read: How to add Developer tab in Word and Excel Office programs.
