When you copy and paste in Excel, a small Paste Options button appears next to the pasted cell. This button offers different paste formats like Values or Formulas. Some users find this button distracting or unnecessary for their workflow. This article explains how to permanently disable this button from appearing. You will learn the exact setting to turn it off.
Key Takeaways: Disabling the Paste Options Button
- File > Options > Advanced > Show Paste Options button: This is the master setting that controls the visibility of the button after every paste operation.
- Ctrl, then V: Using this keyboard shortcut to paste will still trigger the button if the setting is enabled.
- Right-click menu paste: Pasting via the right-click context menu also follows the same global setting.
What the Paste Options Button Does
The Paste Options button is a small icon that appears after you paste content into a cell. It provides a quick menu to change the paste format without redoing the action. For example, you can paste only the values, the formatting, or the formulas from the copied cells. This feature is designed to save time for users who frequently need different paste results.
The button is part of Excel’s standard feedback system for paste operations. It appears whether you paste using the right-click menu, the Home tab, or the Ctrl+V keyboard shortcut. The button stays visible until you perform another action, like typing or clicking elsewhere. While helpful for some, it can be an unwanted visual element in a clean worksheet.
Steps to Disable the Paste Options Button
You can hide the Paste Options button through Excel’s main options menu. This change applies to all workbooks you open in Excel on your computer. The setting is saved in your user profile and will remain off until you enable it again.
- Open Excel Options
Launch Excel and click the File tab in the top-left corner. From the backstage menu, select Options at the bottom of the list. This opens the Excel Options dialog box. - Navigate to Advanced Settings
In the Excel Options dialog, click on the Advanced category in the left-hand pane. This section contains many settings for editing, display, and printing. - Find the Cut, Copy, and Paste Section
Scroll down within the Advanced options until you see the section titled Cut, copy, and paste. It is located below the Display options for this workbook section. - Uncheck the Show Paste Options Button Setting
Look for the checkbox labeled Show Paste Options button when content is pasted. Click the checkbox to remove the checkmark. This action disables the feature. - Apply the Change
Click the OK button at the bottom of the Excel Options dialog to save your change and close the window. The setting takes effect immediately.
Using a Macro to Toggle the Setting
If you need to turn this setting on and off frequently, you can use a VBA macro. This method is for advanced users. You must enable the Developer tab to run macros.
- Open the Visual Basic Editor
Press Alt + F11 on your keyboard. This opens the Microsoft Visual Basic for Applications editor. - Insert a New Module
From the menu, click Insert, then select Module. A blank code window will appear on the right. - Enter the Macro Code
Copy and paste the following code into the module window:Sub TogglePasteOptionsButton()
Application.ShowPasteOptions = Not Application.ShowPasteOptions
End Sub - Run the Macro
Close the Visual Basic Editor. Press Alt + F8, select TogglePasteOptionsButton, and click Run. This macro will switch the button’s visibility on or off.
Common Mistakes and Limitations
The Button Still Appears After Disabling the Setting
If the Paste Options button appears after you have disabled it, restart Excel completely. Close all Excel windows and reopen your workbook. The setting is stored in the application’s memory and may need a fresh start to apply. Also, verify you unchecked the correct setting in File > Options > Advanced.
Setting Does Not Affect Other Users or Computers
This change is specific to your user account on your current computer. If you open the same workbook on a different machine, the button will appear if that Excel installation has the setting enabled. The setting is not saved within the workbook file itself.
No Per-Workbook Toggle Exists
Excel does not provide an option to hide the Paste Options button for only one specific workbook. The setting you change in Options is global. It affects every workbook you open in that instance of Excel. You cannot have it on for one file and off for another.
Global Setting vs. Keyboard Shortcut: Key Differences
| Item | Disable via Excel Options | Use Paste Special Shortcut |
|---|---|---|
| Permanence | Setting remains off until changed | Temporary action for one paste |
| Method | File > Options > Advanced | Ctrl + Alt + V |
| Effect on UI | Button never appears | Button may still flash briefly |
| User skill level | All users | Intermediate users |
| Primary use case | Remove visual distraction permanently | Choose a specific paste format once |
You can now hide the Paste Options button to keep your Excel workspace clean. The setting in File > Options > Advanced provides a permanent solution. For quick paste format choices without the button, learn the Paste Special dialog with Ctrl+Alt+V. An advanced tip is to add the Paste Values command to your Quick Access Toolbar for one-click pasting without any options menu.