Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 6th 05, 02:55 AM
Sam
 
Posts: n/a
Default 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!!

  #2   Report Post  
Old June 6th 05, 03:08 AM
William Benson
 
Posts: n/a
Default

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



  #3   Report Post  
Old June 6th 05, 03:22 AM
Peo Sjoblom
 
Posts: n/a
Default

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


  #4   Report Post  
Old June 21st 05, 05:11 PM
Guy
 
Posts: n/a
Default

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



  #5   Report Post  
Old June 21st 05, 06:40 PM
gazornenplat
 
Posts: n/a
Default


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



  #6   Report Post  
Old August 15th 08, 11:44 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 336
Default 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!!

  #7   Report Post  
Old December 23rd 09, 06:17 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2009
Posts: 1
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Keyboard Shortcut for moving between Worksheets mjcoco Excel Discussion (Misc queries) 3 June 3rd 05 03:35 PM
Keyboard shortcut to open links annonymous Excel Discussion (Misc queries) 0 April 7th 05 11:23 AM
Keyboard shortcut for "copy paste special values?" Star AJ Excel Discussion (Misc queries) 2 March 17th 05 05:03 PM
keyboard shortcut Aditya Excel Worksheet Functions 1 February 21st 05 02:34 PM
Is there a keyboard shortcut for centering data in Excel? Antartica Excel Discussion (Misc queries) 2 November 30th 04 06:30 PM


All times are GMT +1. The time now is 07:29 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017