Keyboard shortcut for Paste Special-Values

[skoeske]

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/com...dg=microsoft.public.excel.worksheet.functions

 

[M Kan]

You can use the ALT shortcuts too. Paste Special Values is ALT+E,S,V

This works for both PowerPoint and Word.

HTH

 

[Mark]

Not sure specifically, but in Word it is Ctrl/Alt/v.

Cheers, Mark

 

[RagDyer]

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:
"Paste Values" (clipboard icon with a 12 on it).

Then click on it and drag to your toolbar.

 

[Michael]

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]

Perhaps an addition would be the ability to assign meaning to an ope
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 i excel
2007 and is quite useful.

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 option
and assign it the hot key combination you want. Works here.