Creating a Shortcut for Pasting Values

@ Larry, have you checked - ALL COMMANDS - VALUES (Paste Values) ?

I'm using Win 11 on a PC with Office Home and Student 2021. The Paste Values option for the QAT is not there under ALL COMMANDS or COMMANDS NOT IN THE RIBBON.

There is a standaard shortcuts for paste valies.
Ctrl+shift+v

I forgot to add that for Excel you can similarly add to the Quick Access Tool bar, and if you select "Show Quick Access Toolbar" checkbox, then you can also use Alt-1, Alt-2, etc. to access them.

I add to the quick access toolbar in MS Word 2021 "Merge Formatting [Paste and Merge Formatting] (PasteMergeFormatting)" and ""Keep Text Only [Paste and Keep Text Only] (PasteTextOnly)" and I move them to the 1st and second positions. I can then use Alt-1 and Alt-2 to access them automatically. I am not sure which version of MS Word this was introduced.

@rjp
Also, look for "Formatting (Paste Formatting)".

@rjp
Look for "Values (Paste Values)".

I had to reinstall Office 2019, and I no longer see "Paste Value" and "Paste Format" in the All Commands list for the Quick Access Toolbar. Did they disappear?

Using Excel v.2111, most of the Paste options, such as Paste Formulas, Paste Values, Paste Formats, are apparently no longer included on the All Commands list for Quick Access Toolbar customization.

There are 3 'paste values' options to add to your quick access toolbar in v2019 & 2016...

Just confirming that the legacy "Alt+E, S, V, Enter" keystroke combination, still works in Office 365, as of this date.

Thanks a lot for showing all the available options in a step by step way.

Thanks

Scrolling down to the bottom, I just now noticed the comment by Steve Jez about accessing the buttons on the QAT by number. This tip might even merit a nugget of its own.

Correction. To be uber efficient. Add a Copy command and Paste command to the Quick Access bar, then just use Alt+5,6.... Boom done!!! Of course, you would change the numbers to the number of the command on your quick access. Your welcome. :)

If you add the Paste Values to the quick access at the top then pressing the Alt shortcut gives you direct access to the Paste values, for example in my case: Prec Ctrl+C to copy and Alt+5 to apply the paste value. This is the shortest combo.

Allen, you rock! Macro to pasteval helps me alot.

Might there be a way of protecting formatting, such that the data/formulas paste, but the "formatting" end of the pasting is effectively disabled because the formatting is "locked"?

thanks again ...

Unfortunately, not having a Ctrl+Z (or alternate) "undo" isn't viable. Restoring manually would be for too time consuming and, in some cases, "impossible" (for all intents and purposes).

I've seen a variety of alternate "paste" methodologies, but the issue I'm facing is multiple users who, almost invariably resort to their own habitual default. There is no way I can reset ***their*** defaults - particularly since they are not the ones that have to deal with the tedious and time consuming restoration of the formats they have blown-up.

Is there any way, through additional code in the otherwise-perfect macro, through an additional macro, or some other arcane and mystical fix, to supplement the provided solution in a way that Ctrl+Z (and/or other "undo" options) can be made to work?

Thanks.

mng

Sub PasteVal()
Selection.PasteSpecial Paste:=xlValues
End Sub
...does not work in Office 365 Pro Excel 2016.

As well, my macros (Record Macro) that worked in 2010 do not work in 2016. Always result in "Runtime error "1004" Pastespecial method of Range class failed."

Terrance's and Stephen's suggestions work well for pasting data between cells, but the topic at hand was general purpose pasting, e. g., from a Web page or the File Explorer, which requires my slightly longer shortcut into the Paste Special dialog box.

I like Alt , E, S, V for paste value and
Alt, E, S, T for formats.

You can also do similar to access the quick access toolbar if you added it there Alt and a number key (can assign macros there too)

There is a much shorter path to Paste Special that leverages the Excel 97/2000/2002/2003 keyboard accelerators, many of which still work through at least Excel 2013, and probably 2016 as well.

Unicode Text: ALT E, S, U
Text: ALT E, S, T

Combine Lanier & Paul's tip:

Right click the cell destination
Mouse over Paste Special
Press V

In Excel 2013 I just right click the cell where I want to paste and I get a pop-up menu where there are a choice of paste options, including Values. About as simple as it gets.

I use
CTRL + V
CTRL (on its own, this activates the Paste Options menu)
V for Values

So CTRL+V, CTRL, V

Alt,h,v,v
is as far as I know the shortest.

If you add the shortcut to the Quick Access Toolbar & move it to the left hand side of the toolbar all you have to do is hit Alt & the number of the button. ie. if you move it to the first button then you just need to hit Alt then 1.

Alt-E, S, V always works for me.