Excel - Keyboard shortcut for Paste Special-Values

Asked By skoesk on 18-Jul-08 03:24 PM
I find myself using "Paste Special - Values" a ton, a keyboard shortcut for
this function would be fabulous.

I'd also like to see a keyboard short cut for "Paste Special" in powerpoint
to drop spreadsheets and graphs in as pictures.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/community/en-us/default.mspx?mid=57e59b73-c2df-4ae0-8bd7-619444e0759b&dg=microsoft.public.excel.worksheet.functions




tipsoftheweek at gmail dot com replied on 18-Jul-08 03:29 PM
You can use the ALT shortcuts too.  Paste Special Values is ALT+E,S,V

This works for both PowerPoint and Word.

HTH
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips
Mark replied on 18-Jul-08 03:30 PM
Not sure specifically, but in Word it is Ctrl/Alt/v.

Cheers, Mark
RagDyer replied on 18-Jul-08 04:19 PM
You can add "Paste Values"  to your toolbar.

Right click in the toolbar and choose "Customize".

Under the <Commands> tab,
in the left window, click on "Edit".

In the right window, scroll down until you see:

Then click on it and drag to your toolbar.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
Michael replied to skoesk on 10-Apr-10 01:55 AM
Perhaps an addition would be the ability to assign meaning to an open hot
key, example ctrl-alt-shift-v might mean past values in Excel.

The ctrl-alt-v does indeed bring up the past special dialog box in excel
2007 and is quite useful.
p45cal replied to Michael on 10-Apr-10 06:53 AM
Michael;695668 Wrote:
Perhaps an addition would be the ability to assign meaning to an open
hot
excel



Easier for one hand:
Alt+e, then s,v,Enter

Apart from that, you can; create this macro:


VBA Code:
--------------------


Sub Macro5()
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
End Sub

--------------------



then in the- Macros|View Macros- dialogue box, select it, click options
and assign it the hot key combination you want. Works here.


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: 558
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=194555

http://www.thecodecage.com/forumz