Keyboard Shortcut for "Paste Values"?
 

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!!

Answer: Keyboard Shortcut for "Paste Values"?
 

Hi there!

The keyboard shortcut for "Paste Values" in Microsoft Excel is "ALT-E-S-V". Here's how you can use it:

1. First, copy the cell or range of cells that you want to paste as values.
2. Next, select the cell or range of cells where you want to paste the values.
3. Press "ALT-E-S-V" on your keyboard.
4. The values that you copied will be pasted into the selected cells as values only.

That's it! Using this keyboard shortcut can save you a lot of time and effort compared to using the mouse to navigate through the "Paste Special" menu.

I do not know one but there is a button for it.

Right click toolbar, customize, Commands, Edit, Paste Values (icon)


"Sam" wrote in message
...
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 altesv + enter

--
Regards,

Peo Sjoblom

(No private emails please)


"Sam" wrote in message
...
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 altesv + enter

--
Regards,

Peo Sjoblom

(No private emails please)


"Sam" wrote in message
...
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


--
gazornenplat
------------------------------------------------------------------------
gazornenplat's Profile: http://www.excelforum.com/member.php...o&userid=24494
View this thread: http://www.excelforum.com/showthread...hreadid=376668

Keyboard Shortcut for "Paste Values"?
 

If the Paste Values button is already on your toolbar
right click on the toolbar, click "customise".
right click Paste Values button.
select "Text Only (Always)" (button now displays "Paste Values"(P underlined).
Close Customise Toolbar window.
Now after you copy something, you can Paste Values by pressing "Alt" then
"P"(because P of Paste Values is underlined)

"Sam" wrote:

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!!

Keyboard Shortcut for "Paste Values"?
 

hello

what i have done that work perfect for me is pess alt+e+s+v
you dont have to press them all at the same time just one at the time, when
you get used to do it will be really easy to use this works in 2003 and 2007
as well

hope this helps