Hello
Please help - the keyboard shortcut for "Paste" is
"CTRL-V". What is the shortcut for
"Paste Values" [i.e., the equivalent using the mouse to
click "Paste - Paste Special - Values - Ok"?]
Thank you!!
Hello
Please help - the keyboard shortcut for "Paste" is
"CTRL-V". What is the shortcut for
"Paste Values" [i.e., the equivalent using the mouse to
click "Paste - Paste Special - Values - Ok"?]
Thank you!!
I do not know one but there is a button for it.
Right click toolbar, customize, Commands, Edit, Paste Values (icon)
"Sam" <[email protected]> wrote in message
news:[email protected]...
> Hello
>
> Please help - the keyboard shortcut for "Paste" is
> "CTRL-V". What is the shortcut for
> "Paste Values" [i.e., the equivalent using the mouse to
> click "Paste - Paste Special - Values - Ok"?]
>
> Thank you!!
No keyboard shortcut except the obvious alt>e>s>v + enter
--
Regards,
Peo Sjoblom
(No private emails please)
"Sam" <[email protected]> wrote in message
news:[email protected]...
> Hello
>
> Please help - the keyboard shortcut for "Paste" is
> "CTRL-V". What is the shortcut for
> "Paste Values" [i.e., the equivalent using the mouse to
> click "Paste - Paste Special - Values - Ok"?]
>
> Thank you!!
In Excel it is possible paste the value (and not the formatting) of a copied
item by double clicking a cell and then Ctrl + V
"Peo Sjoblom" wrote:
> No keyboard shortcut except the obvious alt>e>s>v + enter
>
> --
> Regards,
>
> Peo Sjoblom
>
> (No private emails please)
>
>
> "Sam" <[email protected]> wrote in message
> news:[email protected]...
> > Hello
> >
> > Please help - the keyboard shortcut for "Paste" is
> > "CTRL-V". What is the shortcut for
> > "Paste Values" [i.e., the equivalent using the mouse to
> > click "Paste - Paste Special - Values - Ok"?]
> >
> > Thank you!!
>
>
Set up a macro
'---------------------------------------------------------
Sub PasteValues()
Selection.PasteSpecial Paste:=xlValues
End Sub
'---------------------------------------------------------
then assign a shortcut key to it
Only way I know
Gaz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks