How to Get Rid of the Paste Options Box in Excel 365

To stop Excel for Microsoft 365 on Windows from showing the floating Paste Options button after you paste, go to File > Options > Advanced, clear Show Paste Options button when content is pasted under Cut, copy, and paste, then select OK. To dismiss a button that is already visible, press Esc or click another cell. Turning off the setting prevents the button from appearing after future pastes; it does not undo or change the pasted data.

What You’ll Need

Excel for Microsoft 365 on a Windows computer. The steps below also generally apply to recent desktop versions of Excel, though labels can differ slightly.
Permission to change Excel’s application options. The setting is in Excel, not in the worksheet, so you do not need to edit the workbook or have a particular cell selected.

Step-by-Step

Finish or dismiss the current paste control. If the Paste Options button is already next to a pasted range, press Esc once or click a blank area of the worksheet. This hides the current control; it does not turn it off permanently. If you are still copying a range, Esc may also clear the moving dashed outline around the copied cells.
Open Excel’s options. Select the File tab at the top left of the Excel window. In the backstage view, choose Options, usually near the bottom of the left-hand menu. If you cannot see Options, maximize the Excel window or scroll the menu. This opens the Excel Options dialog.
Go to the Advanced settings. In the left-hand list in the Excel Options dialog, select Advanced. The page contains many settings, so do not change unrelated choices such as calculation or display options while looking for the paste control.
Find the Cut, copy, and paste section. Scroll down the Advanced page until you see the heading Cut, copy, and paste. It is usually below editing options. The dialog has its own scroll bar; move that bar rather than scrolling the worksheet behind it.
Turn off the Paste Options button. Clear the checkbox named Show Paste Options button when content is pasted. This is the specific control for the small floating button that appears beside pasted cells. Leave other paste-related choices as they are unless you intentionally want to change how Excel handles pasted content.
Save the preference. Select OK at the bottom of the dialog. The setting takes effect for subsequent pastes in desktop Excel. Copy a few cells and paste them into another area to confirm that the data appears without the floating Paste Options button.
Use the button setting separately from paste behavior. Turning off the button removes the quick choices that appear after pasting, but it does not disable copying, pasting, or Excel’s normal paste shortcuts. Use Ctrl+C and Ctrl+V as usual, or use Home > Paste to choose a paste command from the ribbon.

The control is useful to understand before disabling it: the Paste Options button is a small clipboard-style control that appears near a recently pasted selection. Selecting it can offer choices such as keeping source formatting, matching the destination formatting, or pasting values. The available choices depend on what you copied and where you pasted it. The button does not mean Excel is waiting for you to finish the paste; the content has already been inserted.

If you only find the button mildly annoying and still use its choices, you may prefer to dismiss it only when it appears. If you rarely use those choices, turning off the checkbox is more convenient. You can return to the same checkbox and select it again at any time.

Common Mistakes

Looking for the setting in the ribbon. The persistent on/off control is in File > Options > Advanced, not in the standard Home tab’s Paste menu. The ribbon can change what gets pasted, but it does not replace this preference.
Confusing the button with the clipboard history panel. The floating Paste Options button sits beside the range you just pasted. The Windows clipboard history panel is a separate feature, typically opened with Windows key+V. Disabling the Excel checkbox does not turn off Windows clipboard history.
Assuming the paste did not work. The button appears after the content is pasted. If you dismiss it, the pasted cells remain. Check the destination cells before repeating a paste, or you may accidentally insert duplicate data.
Changing other advanced settings. The Advanced page includes options for editing, display, and formulas. Clear only Show Paste Options button when content is pasted if your sole aim is to hide the button. Changing nearby settings can alter how Excel behaves in ways unrelated to this issue.
Expecting the setting to affect every Excel app. The Windows desktop preference does not necessarily carry over to Excel for the web or Excel for Mac. Set the preference in the version you actually use.

Tips

Use Esc for a quick dismissal. When the button is visible, press Esc once. If you are copying cells and want to paste them elsewhere, do that before pressing Esc, because Esc can also cancel the active copy selection indicated by the moving border.
Click outside the pasted range. Clicking another cell or a clear part of the worksheet usually dismisses the control without changing the pasted cells. Avoid clicking the Paste Options icon itself unless you want to open its choices.
Keep paste choices available through the ribbon. Hiding the floating button does not remove the commands on the Home tab. For example, when you need a special paste, use Home > Paste and choose an available option such as Values. The exact choices vary according to the copied material.
Remember that this is an application preference. It is not a cell format, worksheet setting, or workbook feature. You do not need to save the workbook for the checkbox change to work, though you should still save any data edits you made.
Restore the button if your workflow changes. Revisit the checkbox and select it again if you later want the contextual choices beside pasted ranges. The change is reversible and does not require reinstalling or repairing Office.

Troubleshooting

The button still appears after I cleared the checkbox. First confirm you selected OK to close Excel Options; closing the dialog with the X may discard the change. Reopen File > Options > Advanced, scroll to Cut, copy, and paste, and verify that the checkbox remains clear. Then try a new copy-and-paste operation. A button already on screen may remain until dismissed, so press Esc or click another cell before checking the next paste.

I cannot find the checkbox. Make sure you are in the desktop Excel application, not a browser tab or another Office program. In the Excel Options dialog, select Advanced and scroll the dialog’s own contents down to the Cut, copy, and paste section. If the interface is narrow, maximize the window. Your Excel build or language may use slightly different wording, but look for the option that says to show Paste Options after content is pasted.

I’m using Excel for Mac. Mac menus are different from Windows. In Excel, open Excel > Preferences (called Settings in some releases), choose Edit, and look for the Paste Options buttons setting; clear it if your version provides it. The wording and location can vary by Mac release. If you do not see a persistent checkbox, dismiss the button with Esc or by clicking elsewhere, and check Excel’s current preferences after updating the app.

I’m using Excel for the web. The Windows path File > Options > Advanced is not available in the browser version. Dismiss the displayed control with Esc or by clicking another cell. If you need a persistent setting and it is not offered in your web version, open the workbook in the desktop Excel app and change the option there. Do not assume that a preference in one version automatically changes the behavior of another.

The button disappears, but the pasted formatting is still wrong. Hiding the button only removes the on-screen control; it does not change which paste action Excel performs. Undo the paste with Ctrl+Z if appropriate, then paste again using Home > Paste and select the option you need. For example, use a values-only choice when you want results without the source cell formatting. Check the destination before undoing if you have made other changes since the paste.

Frequently Asked Questions

Does turning off Paste Options stop me from pasting?

No. It hides the floating button that offers extra choices after a paste. Copy and paste continue to work with Ctrl+C and Ctrl+V, the ribbon, and other available commands.

Will Excel remove the data I have already pasted?

No. The checkbox controls whether the button appears after future pastes. Dismissing the button also leaves the pasted content in place. To remove or change pasted data, edit the cells or use Undo if the paste is the most recent action.

Can I hide the Paste Options button just once?

Yes. Press Esc or click another cell to dismiss the current button. That does not change the persistent setting, so it can appear again after a later paste if the checkbox remains selected.

Is Paste Options the same as Paste Special?

No. Paste Options is the small contextual button shown after a paste. Paste Special is a command for choosing what to transfer, such as values or formatting. Hiding the button does not remove Paste Special or the paste commands on the ribbon.

Does this setting apply to every workbook?

In desktop Excel for Windows, it is an Excel application preference rather than a workbook-specific setting, so it affects your use of Excel rather than just one sheet. Excel for the web and Mac can have separate controls and behavior.

What if I want the button back later?

Return to File > Options > Advanced, select Show Paste Options button when content is pasted in the Cut, copy, and paste section, and choose OK.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.