How can I put a "Paste Formula" command on to the toolbar similar to the
"Paste Formatting" and "Paste Values"

Having to go to Past Special and select it every time is a pain.

There is no such Icon.

You would have to use a macro assigned to a button.

Sub Paste_Formulas()
Selection.PasteSpecial Paste:=xlPasteFormulas
Application.CutCopyMode = False
End Sub

Select a range and copy.

Select a destination cell then hit button to run macro.

No error-checking in macro.


Gord Dibben MS Excel MVP

On Thu, 18 Feb 2010 14:31:01 -0800, Ross in Oz
wrote:

How can I put a "Paste Formula" command on to the toolbar similar to the
"Paste Formatting" and "Paste Values"

Having to go to Past Special and select it every time is a pain.