Keyboard shortcut for Paste Special-Values

S

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

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
 
R

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.
 
M

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.
 
P

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top