Excel - Keyboard shortcut for Paste Special-Values

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

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

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

Cheers, Mark

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 !
---------------------------------------------------------------------------

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.

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