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

excel default paste
Sara picture Sara · Aug 3, 2015 · Viewed 43.2k times · Source

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

Cohan picture Cohan · Aug 3, 2015

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.

Related questions

Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") …

Read More
'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

I'm trying to get data from an Excel file on a button click event. My connection string is: string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\source\\SiteCore65\\Individual-Data.xls;Extended Properties=Excel 8.0;"; When I click on the button, …

Read More