Paste Special

[Gerry]

Is the a way to Paste, Special, Value with a keyboard shortcut in Excel
2000 or would a simple macro be a solution?

TIA



~~~~


Gerry
~~~~
FCA
Stourport, England
Enquire, plan and execute
~~~~~~~~~~~~~~~~~~~

 

[M Kan]

You can use the ALT shortcuts = ALT+E,S,V

 

[Gerry]

Sorry I cannot get it to work.

Have you tested it in Excel 2000?



~~~~


Gerry
~~~~
FCA
Stourport, England
Enquire, plan and execute
~~~~~~~~~~~~~~~~~~~

 

[John C]

I don't have xl2000, but you can probably figure it out for yourself.

I am assuming your Edit menu has the E underlined. This would represent the
Alt+E portion.
Under the Edit menu, find the letter that is underlined for the Paste
Special menu choice. In xl2003, it is the S from Special. This will bring up
the Paste Special Box. The V in values is underlined, so in xl2003, ALT+E, S,
V will be paste special (then press the OK button or the enter key).

It's been too long since I have had xl2000, so don't remember the menu setup
from it.

 

[Gerry]

John

I looked at a copy of Excel 2007 I have acquired but not yet used. I
didn't realise how different the user interface is from Excel 2000. As
I could not get 28/05/2007 to display in that format after having
customised the date formats throuh Control Panel I gave up on testing in
Excel 2007.

Going back to Excel 2000 I have now got your suggestion to work. Either
I misunderstood what you meant when you said "ALT+E, S, V" or it works
slightly differently in Excel 2000. Holding down the ALT I keyed in
E+S+V and it worked. However the process is even more cumbersome than
using the mouse and making selections in the drop down menu. May be a
macro is the answer triggered by a Ctrl +??.

Thanks for your help.

~~~~


Gerry
~~~~
FCA
Stourport, England
Enquire, plan and execute
~~~~~~~~~~~~~~~~~~~

 

[John C]

Posted back in 2007 by Dave Peterson.

Saved from a previous post:

You can get to via Tools|customize|Commands Tab|Edit category
Drag the "Paste Values" icon to your favorite toolbar (or create new
customized
toolbar).

Other people have created macros that they assign to shortcut keys (and load
with their personal.xl* file so it's always available).

Something like:

Option Explicit
Sub MyPasteSpecialValues()
If Application.CutCopyMode = False Then
Beep
Else
ActiveCell.PasteSpecial Paste:=xlPasteValues
End If
End Sub

The assign it a nice shortcut key (Ctrl-Shift-V??).

Tools|Macro|Macros
Select the macro
Click Options
type in your shortcut key (case is important)
Ok out of that dialog
Cancel out of this one.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm