Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
O-07 Paste Special Values icon
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
O-07 Paste Special Values icon
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
O-07 Paste Special Values icon
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
O-07 Paste Special Values icon
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
O-07 Paste Special Values icon
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste special values but not... | Excel Worksheet Functions | |||
Paste Special - Values | Excel Worksheet Functions | |||
paste special values | Excel Worksheet Functions | |||
Paste Special values only | Excel Worksheet Functions | |||
paste special values | Excel Worksheet Functions |