Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcuts
Is there any addin for better support of shortcuts.
If I want to create a new book there is a shortcut CTRL+U, etc, but if I want to paste special, or paste only values, ther are no shortcuts. Thanks JPG |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcuts
Click VIEW in the menu, TOOLBARS and select CUSTOMIZE.
Click the COMMANDS tab and in the CATEGORIES panel select EDIT. In the COMMANDS panel locate the PASTE VALUES command and the click & drag the icon to the formatting toolbar. -- Kevin Backmann "juanpablo" wrote: Is there any addin for better support of shortcuts. If I want to create a new book there is a shortcut CTRL+U, etc, but if I want to paste special, or paste only values, ther are no shortcuts. Thanks JPG |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcuts
hi
create your own...... Paste this into a standart module. Sub specialpaste() ActiveCell.PasteSpecial Paste:=xlPasteValues, _ Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub the go toolsmacromacrosclick the options button assign your short cut key regards FSt1 "juanpablo" wrote: Is there any addin for better support of shortcuts. If I want to create a new book there is a shortcut CTRL+U, etc, but if I want to paste special, or paste only values, ther are no shortcuts. Thanks JPG |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcuts
But I dont want a button, I want a CTRL + key, like in the mac, all options
have shortcuts. JP "Kevin B" wrote: Click VIEW in the menu, TOOLBARS and select CUSTOMIZE. Click the COMMANDS tab and in the CATEGORIES panel select EDIT. In the COMMANDS panel locate the PASTE VALUES command and the click & drag the icon to the formatting toolbar. -- Kevin Backmann "juanpablo" wrote: Is there any addin for better support of shortcuts. If I want to create a new book there is a shortcut CTRL+U, etc, but if I want to paste special, or paste only values, ther are no shortcuts. Thanks JPG |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcuts
For the macro offerred by FSt1 to work in all workbooks you'll want to place
it in the Personal.xls workbook so that it can be accessed by any workbook. -- Kevin Backmann "FSt1" wrote: hi create your own...... Paste this into a standart module. Sub specialpaste() ActiveCell.PasteSpecial Paste:=xlPasteValues, _ Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub the go toolsmacromacrosclick the options button assign your short cut key regards FSt1 "juanpablo" wrote: Is there any addin for better support of shortcuts. If I want to create a new book there is a shortcut CTRL+U, etc, but if I want to paste special, or paste only values, ther are no shortcuts. Thanks JPG |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcuts
In Excel 2007 you can right click on the cell you want to
paste into then choose from the format (values). Otherwise, you might want to take a look at the following Right Click Menus (Context Menus) in Excel http://www.mvps.org/dmcritchie/excel/rightclick.htm or with a shortcut key Ctrl+SHIFT+V (my choice of shortcut) http://www.mvps.org/dmcritchie/excel/paste.htm#values might also look at http://www.mvps.org/dmcritchie/excel...x2k.htm#mykeys -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Kevin B" wrote in message ... For the macro offerred by FSt1 to work in all workbooks you'll want to place it in the Personal.xls workbook so that it can be accessed by any workbook. -- Kevin Backmann "FSt1" wrote: hi create your own...... Paste this into a standart module. Sub specialpaste() ActiveCell.PasteSpecial Paste:=xlPasteValues, _ Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub the go toolsmacromacrosclick the options button assign your short cut key regards FSt1 "juanpablo" wrote: Is there any addin for better support of shortcuts. If I want to create a new book there is a shortcut CTRL+U, etc, but if I want to paste special, or paste only values, ther are no shortcuts. Thanks JPG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
old shortcuts | Excel Discussion (Misc queries) | |||
Keyboard Shortcuts | Excel Discussion (Misc queries) | |||
Shortcuts to go to cell | Setting up and Configuration of Excel | |||
shortcuts | Excel Discussion (Misc queries) | |||
Look in shortcuts. | Excel Worksheet Functions |