You can add this option to the QAT if you want

On the Home tab, in the Clipboard group, there is a paste button. Click this
to open a dropdown of which PasteValues is one option

Then right click on the values option and choose add to QAT

With code you can run this macro one time to get it in the first level of the right click menu

Sub Add_Paste_Special_Button()
' This will add the Paste Special Values button to the cell menu
' after the Paste option
Dim Num As Long
Num = Application.CommandBars("Cell"). _
FindControl(ID:=755).Index
Application.CommandBars("cell").Controls. _
Add Type:=msoControlButton, ID:=370, befo=Num
End Sub

Sub Delete_Paste_Special_Button()
On Error Resume Next
Application.CommandBars("cell").FindControl(ID:=37 0).Delete
On Error GoTo 0
End Sub



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jolson46" wrote in message ...
Thank you so much! I came to ask the same question (I'm also a right-clicker
who was looking for a shorter route).

Jen

"Frank zuehlke" wrote:

Bob,
Thank you!

I haven't used that paste button because I always right click after
copying(using right click as well). I see the available options now.

Frank

"Bob Phillips" wrote:

On the Home tab, in the Clipboard group, there is a paste button. Click this
to open a dropdown of which PasteValues is one option.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Frank zuehlke" wrote in message
...
In O-03 I use the Paste Special values icon all the time. I am now using
O-07 and can't find this icon. I have the Paste Special but I then have
to
selecte the Values radio button.

Does anyone know how to get the Values icon or did Microsoft determine it
wasn't needed? No I don't want to create a macro, I just want the icon.

Thanks,
Frank