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

Page updated :

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.