Hide the paste options that appear after you paste a value into a cell in Excel

Page creation date :

When you paste some data into an Excel cell, a Ctrl Tip called Paste Options appears in the lower right.


This menu has useful features such as formatting the data pasted after pasting the value, but because it overlaps the lower right cell, it may interfere if you paste frequently. This section provides step-by-step instructions on how to hide this option.

Select Options from the file menu.


Select Advanced from the left menu, uncheck "Show paste options" button when pasting content from the "Cut, copy, paste" group, and click the OK button in the lower right.


The image is from Excel 2010, but you can do the same in Excel 2013.