When you put something in Microsoft Excelit displays a button named Paste Options. However, if you want to hide the Paste Options button after pasting data into Excel, you can do so using Excel’s built-in preferences, the Registry Editor, and the Local Group Policy Editor.

Excel shows a button when you insert data into a spreadsheet. This will help you customize the data according to your requirements. For example, you can continue to use the original format, paste data in a specific way, etc. However, if you don’t want these options and want to get rid of this annoying option, this guide will definitely help you.

How to remove Paste Options button after pasting in Excel

To hide the Paste Options button after pasting in Excel, follow these steps:

1. Open Microsoft Excel on your computer.
2. Press File option.
3. To choose Options.
4. Go to Advanced tab
5. Uncheck the Show Paste Options button when pasting content checkbox.
6. Press Ok button.

To learn more about these steps, keep reading.

First, you need to open Microsoft Excel on your computer and click on the button file menu in the top menu bar. Then select Options visible in the bottom left corner to open Excel Options panel.

Next, switch to Advanced tab and find Show Paste Options when content is pasted checkbox.

Uncheck the corresponding checkbox and click the button OK button to save changes.

This is all! After that, you won’t be able to find the “Paste Options” button after pasting data into any spreadsheet.

How to hide the Paste Options button after pasting in Excel using the Registry

To remove the Paste Options button after pasting in Excel using the registry, follow these steps:

1. Search regedit in the search box on the taskbar.
2. Click on an individual search result and click the button Yes button.
3. Switch to general in HKCU.
4. Right click general > new > keyand call it like General.
5. Right click General > New > DWORD Value (32-bit).
6. Set name as paste parameters.
7. Restart your computer.

Let’s take a look at these steps in detail.

First you need to open the Registry Editor. For this you can search regedit or registry editor in the search box on the taskbar and click an individual search result. Then click on Yes button at the UAC prompt.

After opening it, navigate to the following path:

HKEY_CURRENT_USERSoftwarePoliciesMicrosoftoffice16.0common

There’s a chance you won’t find office key. In this case, right click Microsoft > New > Keyand call it like office. Then repeat the same steps to create other subsections.

One day general the key is created, right click on it, select New > Keyand call it like general.

Then you need to create a REG_DWORD value. To do this, right-click general > New > DWORD (32-bit) Value and set the name as pasteoptions.

Since you want to hide the “Paste Options” button, you need to save the “Value” data as 0. Finally, restart your computer.

However, if you want to undo the change, you have two options. First, you can remove paste parameters price. Second, you can set the value data like one. To do this, double-click the paste option, enter 1 as the value data, click OK, and restart your computer.

How to hide the Paste Options button after pasting in Excel using Group Policy

To hide the Paste Options button after pasting in Excel using Group Policy, follow these steps:

1. press Win+R to display the Run dialog box.
2. Type gpedit.msc and press To come in button.
3. go to Advanced in User configuration.
4. Double click on Show paste options button when pasting content parameter.
5. Select Defective option.
6. Press Ok button.
7. Restart Microsoft Excel.

Let’s learn more about the above steps in detail.

First press Win+R > type gpedit.msc > click on Enter button to open the Local Group Policy Editor on your computer.

Next follow this path:

User Configuration > Administrative Templates > Microsoft Excel 2016 > Excel Options > Advanced

Double click on Show Paste Options button when content is paste setting and select Disabled option.

Next click on OK and restart Microsoft Excel if it was open at the time of the change.

How to disable paste options?

To disable Paste Options in Excel, you need to follow the above steps. Open Excel, click File > Optionsgo to Advanced tab and find Show Paste Options button when pasting content checkbox. Then uncheck the checkbox and click the button Ok button. In addition, you can also use Group Policy and Registry methods.

How to get rid of autofill options window in Excel?

To get rid of the Autofill Options window in Excel, you need to open Excel Options first. Then switch to Advanced tab and find Enable fill handle and cell dragging parameter. Untick the checkbox and click the button Ok button.

This is all! Hope this guide helped.