• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Managing keyboard shortcuts in Excel 2010

C

chandooto

New Member
Not sure I'm doing this right, but I have a question about keyboard shortcuts - as there is one working with ALT + @ which changes the cell value format and I find no way to get rid of it. So the question is: how can I view all the generic (default by Excel) shortcuts and as well as the customized (eg assigned by macro or magic fat finger) shortcuts ? How can I adjust/remove them in case i want to ? The only tips i found is a list of some/any(?) default shortcuts (eg: http://office.microsoft.com/en-us/excel-help/keyboard-shortcuts-in-excel-2010-HP010342494.aspx), but that doesn't help my problem to get rid of the unwelcome shortcut. Thanks for any input in case!
 
For a more comprehensive list of shortcuts, you might check here:

http://www.cpearson.com/excel/ShortCuts.aspx

You sure you didn't hit Ctrl+Shift+2 instead? (sets a time format)

The custom ones are a little trickier. First place to check, would be to press Alt+F8, select "options" for any macros listed, see what the shortcut is.


Second, would need to check any macros that have a built in shortcut. Open the VB editor (Alt+F11), and navigate to the ThisWorkbook module in the current workbook, and/or in your Personal.xls workbook. You'll be looking for some type of Workbook_Open or Auto_Open macro with lines of code that look like this:

[pre]
Code: 
Application.OnKey "^q", "CalcMe"
[/pre]
This example assigns the keyboard shortcut Ctrl+q to the CalcMe macro.
 
You must log in or register to reply here.
Back
Top