EXCEL Shortcut paste special values 4

[firegambler]

Hi,

does anybody know by chance whether there is a shortcut in EXCEL for 'paste special - values' and 'paste special - formulas'?

Many thanks in advance

regards

 

[KenWright]

There are icons you can add to your toolbar for Paste Values and Paste Special. View / Toolbars / Customize / Commands / Edit - .....

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[AnotherHiggins]

It's a bit cumbersome, but if you are looking for a keyboard shortcut, [Alt], [E], , [V], [Enter] will work. (Note: press these keys in sequence, none have to be held down while others are being pressed.)

[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[firegambler]

Well, I kind of thought of a shortcut like the one for paste 'ctrl+v'...

Anyway now I know that I am not the only one searching this one unavailingly.

Thanks for your help, guys!

regards

 

[AnotherHiggins]

For me, [Alt], [E], , [V] has become second nature.

But if you really want a something like [ctrl]+[v], you can do the following:
[ul][li]Right click on the toolbar[/li]
[li]Choose Customize[/li]
[li]Go to Commands[/li]
[li]Select Edit[/li]
[li]Select Paste Special[/li][/ul]

This was described in KenWright's post. But take it one step further and you'll have a keyboard shortcut.

[ul][li]Now (while the customize dialogue box is still up) right click on the new Paste Special button[/li]
[li]Choose either Text Only (Always) or Image and Text[/li]
[li]Now close the Customize box[/li][/ul]

[Alt]+[P] should now act as Paste Special. You will run into trouble if you have a menu item that uses P for a shortcut. If that is the case, then while in customize:
[ul][li]Change the location of the ampersand (&) in the Name field for the Paste Special button[/li]
[li]Whatever letter follows the ampersand will be the shortcut key - if needed, you can even add a random letter like q to the name following the ampersand. Or you can change the name so it is only &q - that way it takes up less space in your menu area.[/li][/ul]

NOTE: the letter following the ampersand in the name field will appear in the toolbars as underlined, indicating that it is a keyboard shortcut. The ampersand itself will not be visible.

Hope that info is helpful.

[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[sawedoff]

Or you could record a macro, and assign it to Ctrl-v, like so:
Sub PastSpecVal()
'
' PastSpecVal Macro
' Macro recorded 8/2/2005
'

'
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
End Sub

Sawedoff

 

[AnotherHiggins]

Sawedoff,

Good suggestion, but I would add a couple of points for firegambler.

-I would advise against assigning any macro to [Ctrl]+[v] or any other standard keyboard shortcut that excel recognizes. You could assign it to [Ctrl]+[Shift]+[v] instead, however.

-This macro would have to live in your Personal.xls file to be universally accessible.

[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[sawedoff]

I agree wholeheartedly on both counts. Thanks John.

Sawedoff

 

[xlbo]

Personally, I don't need a shortcut for "undo" - I'm quite happy to get that from the toolbar. I have, therefore, set up a macro similar to sawedoff's

Sub pastespec()
Selection.PasteSpecial Paste:=xlValues
End Sub

saved it to my Personal.xls and assigned a shortcut of ctrl+z to it - I can therefore VERY quickly do

ctrl+c
ctrl+v
ctrl+z

I rarely use "Select All" so I did the same to ctrl+a for paste special (formulas)

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[firegambler]

Thanks a lot for your valuable posts guys!

regards