Office Paste Special Shortcut

[Guest]

Does anyone know of a shortcut to Paste Special on Excel 2003? I think Excel
2007 may have one, but I need one for Excel 2003 at work, either an excisting
keyboard shortcut or is it possiable to make a macro and incorprate to a menu
button?

Please advise. Thank you.

 

[Jan Karel Pieterse]

Hi MS,

Does anyone know of a shortcut to Paste Special on Excel 2003? I think Excel
2007 may have one, but I need one for Excel 2003 at work, either an excisting
keyboard shortcut or is it possiable to make a macro and incorprate to a menu
button?

You can drag the paste special button to a toolbar:

- rightclick toolbar, choose customize
- click commands tab
- click "Edit"
- drag Paste Special from the righthand list to a toolbar.

Tip: there are buttons for paste values and paste formats inthat list which I
find most helpful.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[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

============
You may find that modifying your favorite toolbar is safer--if you run a macro,
you'll notice that the Edit|Undo stack is cleared. And sometimes Edit|undo is a
nice safety net.

 

[Don Guillett]

to make formulas into values

Sub makevalues()
Selection.Formula = Selection.Value
End Sub