Keyboard custom commands: paste formulae

[playfoot]

A recent PC convert to Mac OS X....Best thing I ever did.

In finance, do a great deal of number crunching. Like my custom
commands. Have not found a way to create a keyboard command for
"paste formula".

Any ideas?

Thank you in advance.

 

[Jim Gordon MVP]

Hi Playfoot,

The keyboard shortcuts vary depending upon the version of Excel that you are
using.

Search help for "shortcuts" and you'll find the shortcuts for your version
of Excel.

 

[JE McGimpsey]

A recent PC convert to Mac OS X....Best thing I ever did.

In finance, do a great deal of number crunching. Like my custom
commands. Have not found a way to create a keyboard command for
"paste formula".

Any ideas?

Thank you in advance.

If you're talking about the equivalent of Edit/Paste Special/Formulas,
there's no built-in Paste Formula command (unlike, say, Paste Values),
so you'll have to use a macro. Put this in your Personal Macro Workbook
and attach a keyboard shortcut to it (Tools/Macro/Macros..., select the
macro name and click Option):

Public Sub PasteFormula()
On Error Resume Next
Selection.PasteSpecial _
Paste:=xlFormulas, _
Operation:=xlNone, _
SkipBlanks:=False, _
Transpose:=False
On Error GoTo 0
End Sub

OTOH, if you're talking about the Paste Function command (which brings
up the function dialog), choose Tools/Customize, click Keyboard, and
select Paste Function.