Is there a keyboard short cut key to do this in excel 97?

[assws]

I am looking for a keyboard shortcut (like ctrl-c for cut)

that will paste special only values, not formats or formulas.

Does one exist?

Thanks

 

[Peo Sjoblom]

You have to roll your own using VBA.You can place a button that will do it
by customize the toolbars.
Then it takes one mouse click. However if you want a 2 key press shortcut
you need VBA.

 

[Andy Brown]

I am looking for a keyboard shortcut ...

... that will paste special only values, not formats or formulas.

If you *must* have this, here's a nice cheat for it.

Rightclick the menu bar (File, Edit, View, etc.), choose Customize (sic).

On the Commands tab, choose the Edit category. Scroll down in Commands until
you see the Paste Special icon (#12 on a clipboard).

Drag the button to the menu bar. Once it's on your bar, rightclick it & set
to Image & Text or Text Only (Always). Close the Customize dialog.

Unless you've something else custom in the menu bar, you should be able to
"click" it with ALT+P.

Rgds,
Andy

 

[assws]

Thank Yo

 

[Kevin]

Another way I've done this is to create a macro and add a
keyboard shortcut (in my case ctrl-shift-v). Keep in
mind, since this works via a macro, the paste special
CANNOT be undone like it can be through the edit menu.

The code looks like this:

Selection.PasteSpecial Paste:=xlPasteValues,
Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False


I also made one to paste only formulas, it looks like
this:

Selection.PasteSpecial Paste:=xlPasteFormulas,
Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False

Hope this helps!