Shortcuts

[Guest]

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

 

[Guest]

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.

 

[Guest]

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 tools>macro>macros>click the options button
assign your short cut key

regards
FSt1

 

[Guest]

But I dont want a button, I want a CTRL + key, like in the mac, all options
have shortcuts.

JP

 

[Guest]

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.

 

[David McRitchie]

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/shortx2k.htm#mykeys