Clever Geek Handbook

How to set default paste special in excel to paste only values

One of the cells in my excel is being used as a user input box ... IF users are pasting something into this cell. I only want to insert values, not format. Is there a way to set the default insert option to only insert values?

+3


source to share


2 answers


I am using a keyboard shortcut to get past the values. If you press alt

, e

, s

, v

, enter

, he will pass values. (Press the keys in sequence, do not hold the key alt

.)

alt

, e

, s

To open the Paste Special dialog box, v

choose Values

, and then enter

do it. This works well for anything copied from excel.



If you copy something from outside excel, it will give you a few different options to paste special, but alt

, e

, s

it will take you there.

Another option, as mentioned above, is to add a button to the Quick Access Toolbar and then you can click them or use a keyboard shortcut to do so. Items are numbered on the Quick Access Toolbar. Assuming you have a default save, undo and redo, adding insert values ​​will allow you to click alt + 4

(or whatever number appears when you click alt

) and select that action.

+4


source


If you want to change the default palette, go to the options menu in the advanced options: there are options to change the default print options . However , it doesn't seem to work for excel.



As a workaround, you can try to create a new macro or edit an existing one using the office support here . I haven't tried it myself, but with some research it is possible if you really need this modification.

+1


source






More articles:


All Articles