Paste Formula Keyboard Shortcut

[Guest]

Can anyone tell me how to assign a keyboard shortcut to the "Paste Formula"
function?

 

[Dave Peterson]

One way is to create a macro and then use a keyboard shortcut to run that macro:

Put something like this in your personal.xls workbook (so it's available all the
time):

Option Explicit
Sub myPasteSpecialFormulas()
On Error Resume Next
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
If Err.Number <> 0 Then
MsgBox "Paste|special|formulas failed"
Err.Clear
End If
End Sub


Then Tools|options|macro
select mypastespecilformulas
click Options
assign your shortcut key

save your workbook

And test it out.

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

Or you could use:
alt-e-s-t (enter)
(using the accelerator keys in the menu captions)

If you use the macro, be aware that you'll lose Edit|undo.