How do I make PASTE VALUES the default Ctrl+V function in 2010?

**duckdown** · 03-15-2011, 03:31 PM

Hey all.

Excel 2010 is *extremely* annoying. In fact, I hate it.

Every time I try to CTRL+C to copy text from one spreadsheet and paste it into another spreadsheets column with CTRL+V, it's copying all the stupid formulas and junk with it, leaving the box with an N/A in it unless I manually move the mouse of to Paste and choose "Paste Values"

Who's the incredible genius at Microsoft that made copy formula the default paste? What a bunch of idiots.

How can I change the default paste function to be paste VALUES and not paste all the other junk?

Why do they mess with things like this, I just don't get it...

Any speedy answers would be great

Thanks in advance guys

-An Excel 2010 hater.

**ChemistB** · 03-15-2011, 03:50 PM

Unfortunately, you can't. At least not with a push of a button. You can record a macro which pastes values and save that with the shortcut key CNTRL + V. Then, if you have macros enabled, it'll default to that. Does that help?

**FireMedic947** · 09-30-2015, 04:48 PM

"Unfortunately, you can't."

Au contraire mon frère!!!

Create a macro:
Sub PasteValues()
Selection.PasteSpecial Paste:=xlPasteValues
End Sub

Then, in the ThisWorkbook code,

Private Sub Workbook_Activate()
Application.OnKey "^v", "PasteValues"
End Sub

(or add the application.onkey line to the existing Workbook_Activate function)

**IronCladRooster** · 09-30-2015, 04:52 PM

You could add "Paste Values" to your quick access toolbar and use that instead of Ctrl V.

**ChemistB** · 09-30-2015, 05:10 PM

@ FireMedic, you didn't read my whole post.

As Duckdown only posted once and that was 4 years ago, I'm guessing he's not monitoring the board at this point.

**FireMedic947** · 09-30-2015, 08:32 PM

Originally Posted by IronCladRooster

You could add "Paste Values" to your quick access toolbar and use that instead of Ctrl V.

I do it that way to specifically prevent users from pasting "all" in the workbooks that I develop. I also disable the "cut" functions.

**FireMedic947** · 09-30-2015, 08:34 PM

Originally Posted by ChemistB

@ FireMedic, you didn't read my whole post.

As Duckdown only posted once and that was 4 years ago, I'm guessing he's not monitoring the board at this point.

You are correct....sorry!

**ChemistB** · 10-01-2015, 08:15 AM

As long as we're hijacking this thread, is there an advantage, Firemedic, to putting the code in "thisworkbook" to make the macro respond to CNTRL V as opposed to just going to Macros window>Options and entering the shortcut there?

**mngreen** · 07-10-2017, 05:32 PM

I have a series for worksheets that have very specific report-presentation formatting. The issue I've been trying to resolve is that when my team colleagues are moving/modifying data, the often use the fastest mechanism available, typically Ctrl+C, Ctrl+V ... which frequently blows out the report-presentation formatting. Freaking huge amount of work to have to constantly reformat to restore the desired effect.

This would be precisely *THE* solution that I've been looking for as well, except that, at least in MS EXCEL 2013, a copy/paste with this macro in-place, "undo" is not available. And, inevitably, the undo will be needed from time to time.

Is there a solution where Ctrl-V / undo remains available?

**FDibbins** · 07-11-2017, 01:25 AM

mngreen welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.