When you paste something in Microsoft Excel, it displays a button called Paste Options. However, if you want to hide the Paste Options button after pasting data in Excel, you can do so using in-built Excel settings, Registry Editor, and the Local Group Policy Editor.
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:
- Open Microsoft Excel on your computer.
- Click the File option.
- Select Options.
- Go to the Advanced tab.
- Remove the tick from the Show Paste Options button when content is pasted checkbox.
- Click the OK button.
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:
- Search for regedit in the Taskbar search box.
- Click the individual search result and click the Yes button.
- Navigate to common in HKCU.
- Right-click on common > New > Keyand name it as general.
- Right-click on general > New > DWORD (32-bit) Value.
- Set the name as pasteoptions.
- Restart your computer.
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:
HKEY_CURRENT_USER\Software\Policies\Microsoft\office\16.0\common
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:
- Press Win+R to display the Run dialog.
- Type gpedit.msc and press the Enter button.
- Go to Advanced in User Configuration.
- Double-click on the Show Paste options button when content is pasted setting.
- Choose the Disabled option.
- Click the OK button.
- Restart Microsoft Excel.
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:
User Configuration > Administrative Templates > Microsoft Excel 2016 > Excel Options > Advanced
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.
