If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Keyboard Shortcut to move to top of column in worksheet? | piddilin | General Discussion | 4 | March 21st, 2005 10:49 PM |
keyboard shortcut | Aditya | Worksheet Functions | 1 | February 21st, 2005 01:34 PM |
Office 2003 / Office XP Shortcut Bar | Marc Bressman | Setup, Installing & Configuration | 6 | June 26th, 2004 08:42 AM |
average, eliminating zero values | Chris | Worksheet Functions | 6 | May 14th, 2004 11:36 PM |