How do I set the default paste special in excel to paste only values [closed]

Question

One of the cells in my excel is used as a user entry box... IF users paste something in this cell I want only the values to be pasted and not the format. Is there a way to set the default of paste option to paste only values?

Answer 1

I use a keyboard shortcut to past the values. If you hit Alt, E, S, V, Enter it will past the values. (hit keys in sequence, don't hold down the Alt key.)

Alt, E, S will open the paste special dialog box, V will select Values and then Enter will make it happen. This works well for anything copied from excel.

If you are copying something from outside excel, it will give you some different options for paste special, but Alt, E, S will get you there.

Another option, as @jeeped mentioned, is you can add a button to your quick access toolbar and then you can either click them, or use a keyboard shortcut for those. The items are numbered on the quick access toolbar. Assuming you have the default save, undo, and redo, adding paste values will allow you to hit Alt+4 (or whatever number comes up when you hit Alt) and select that action.