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.
