Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
Is the a way to Paste, Special, Value with a keyboard shortcut in Excel
2000 or would a simple macro be a solution? TIA ~~~~ Gerry ~~~~ FCA Stourport, England Enquire, plan and execute ~~~~~~~~~~~~~~~~~~~ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
You can use the ALT shortcuts = ALT+E,S,V
-- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "Gerry" wrote: Is the a way to Paste, Special, Value with a keyboard shortcut in Excel 2000 or would a simple macro be a solution? TIA ~~~~ Gerry ~~~~ FCA Stourport, England Enquire, plan and execute ~~~~~~~~~~~~~~~~~~~ |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
Sorry I cannot get it to work.
Have you tested it in Excel 2000? ~~~~ Gerry ~~~~ FCA Stourport, England Enquire, plan and execute ~~~~~~~~~~~~~~~~~~~ M Kan wrote: You can use the ALT shortcuts = ALT+E,S,V Is the a way to Paste, Special, Value with a keyboard shortcut in Excel 2000 or would a simple macro be a solution? TIA ~~~~ Gerry ~~~~ FCA Stourport, England Enquire, plan and execute ~~~~~~~~~~~~~~~~~~~ |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
I don't have xl2000, but you can probably figure it out for yourself.
I am assuming your Edit menu has the E underlined. This would represent the Alt+E portion. Under the Edit menu, find the letter that is underlined for the Paste Special menu choice. In xl2003, it is the S from Special. This will bring up the Paste Special Box. The V in values is underlined, so in xl2003, ALT+E, S, V will be paste special (then press the OK button or the enter key). It's been too long since I have had xl2000, so don't remember the menu setup from it. -- John C "Gerry" wrote: Sorry I cannot get it to work. Have you tested it in Excel 2000? ~~~~ Gerry ~~~~ FCA Stourport, England Enquire, plan and execute ~~~~~~~~~~~~~~~~~~~ M Kan wrote: You can use the ALT shortcuts = ALT+E,S,V Is the a way to Paste, Special, Value with a keyboard shortcut in Excel 2000 or would a simple macro be a solution? TIA ~~~~ Gerry ~~~~ FCA Stourport, England Enquire, plan and execute ~~~~~~~~~~~~~~~~~~~ |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
John
I looked at a copy of Excel 2007 I have acquired but not yet used. I didn't realise how different the user interface is from Excel 2000. As I could not get 28/05/2007 to display in that format after having customised the date formats throuh Control Panel I gave up on testing in Excel 2007. Going back to Excel 2000 I have now got your suggestion to work. Either I misunderstood what you meant when you said "ALT+E, S, V" or it works slightly differently in Excel 2000. Holding down the ALT I keyed in E+S+V and it worked. However the process is even more cumbersome than using the mouse and making selections in the drop down menu. May be a macro is the answer triggered by a Ctrl +??. Thanks for your help. ~~~~ Gerry ~~~~ FCA Stourport, England Enquire, plan and execute ~~~~~~~~~~~~~~~~~~~ John C wrote: I don't have xl2000, but you can probably figure it out for yourself. I am assuming your Edit menu has the E underlined. This would represent the Alt+E portion. Under the Edit menu, find the letter that is underlined for the Paste Special menu choice. In xl2003, it is the S from Special. This will bring up the Paste Special Box. The V in values is underlined, so in xl2003, ALT+E, S, V will be paste special (then press the OK button or the enter key). It's been too long since I have had xl2000, so don't remember the menu setup from it. Sorry I cannot get it to work. Have you tested it in Excel 2000? ~~~~ Gerry ~~~~ FCA Stourport, England Enquire, plan and execute ~~~~~~~~~~~~~~~~~~~ M Kan wrote: You can use the ALT shortcuts = ALT+E,S,V Is the a way to Paste, Special, Value with a keyboard shortcut in Excel 2000 or would a simple macro be a solution? TIA ~~~~ Gerry ~~~~ FCA Stourport, England Enquire, plan and execute ~~~~~~~~~~~~~~~~~~~ |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
Posted back in 2007 by Dave Peterson.
Saved from a previous post: You can get to via Tools|customize|Commands Tab|Edit category Drag the "Paste Values" icon to your favorite toolbar (or create new customized toolbar). Other people have created macros that they assign to shortcut keys (and load with their personal.xl* file so it's always available). Something like: Option Explicit Sub MyPasteSpecialValues() If Application.CutCopyMode = False Then Beep Else ActiveCell.PasteSpecial Paste:=xlPasteValues End If End Sub The assign it a nice shortcut key (Ctrl-Shift-V??). Tools|Macro|Macros Select the macro Click Options type in your shortcut key (case is important) Ok out of that dialog Cancel out of this one. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm -- John C "Gerry" wrote: John I looked at a copy of Excel 2007 I have acquired but not yet used. I didn't realise how different the user interface is from Excel 2000. As I could not get 28/05/2007 to display in that format after having customised the date formats throuh Control Panel I gave up on testing in Excel 2007. Going back to Excel 2000 I have now got your suggestion to work. Either I misunderstood what you meant when you said "ALT+E, S, V" or it works slightly differently in Excel 2000. Holding down the ALT I keyed in E+S+V and it worked. However the process is even more cumbersome than using the mouse and making selections in the drop down menu. May be a macro is the answer triggered by a Ctrl +??. Thanks for your help. ~~~~ Gerry ~~~~ FCA Stourport, England Enquire, plan and execute ~~~~~~~~~~~~~~~~~~~ John C wrote: I don't have xl2000, but you can probably figure it out for yourself. I am assuming your Edit menu has the E underlined. This would represent the Alt+E portion. Under the Edit menu, find the letter that is underlined for the Paste Special menu choice. In xl2003, it is the S from Special. This will bring up the Paste Special Box. The V in values is underlined, so in xl2003, ALT+E, S, V will be paste special (then press the OK button or the enter key). It's been too long since I have had xl2000, so don't remember the menu setup from it. Sorry I cannot get it to work. Have you tested it in Excel 2000? ~~~~ Gerry ~~~~ FCA Stourport, England Enquire, plan and execute ~~~~~~~~~~~~~~~~~~~ M Kan wrote: You can use the ALT shortcuts = ALT+E,S,V Is the a way to Paste, Special, Value with a keyboard shortcut in Excel 2000 or would a simple macro be a solution? TIA ~~~~ Gerry ~~~~ FCA Stourport, England Enquire, plan and execute ~~~~~~~~~~~~~~~~~~~ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
'paste special', 'paste link' formatting transfer | Excel Discussion (Misc queries) | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
Paste and Paste Special command are not enabled in Excel | Excel Worksheet Functions |