up vote 2 down vote favorite
share [g+] share [fb]

I have a copy of Excel 2007 that happens to be in Brazilian Portuguese. For me it's great since I'm in Brazil but there is a catch.

All the English shortcuts I'm used to, like Ctrl+S for saving, Ctrl-B for bold etc. are also translated.

When I press Ctrl-S it thinks I want to underline the text.

How do I change the shortcuts to the English default?

link|improve this question
feedback

1 Answer

up vote 2 down vote accepted
+50

One possibility is to simply recreate the shortcuts as macros :

  1. Go to the Developer tab and press Record Macro
  2. Fill the macro's description and shortcut key, and set its placement in "Personal Macro Workbook" and press OK
  3. Do your action
  4. Go to the Developer tab and press Stop recording.

The Personal Macro Workbook is a hidden workbook that opens when you start Excel. The code you copy in this workbook is available in all workbooks you have opened in Excel.

More info in:
How to Create Custom Keyboard Shortcuts in Excel 2007?
How do I create a PERSONAL.XLS

link|improve this answer
This aproach works. But I have to create macros for each and every single shortcut I want to change. I wish there is a way of justing changing the shortcuts not creating macros. – pablosaraiva Aug 22 '11 at 18:49
I didn't find any other way of changing the keyboard mapping for Excel. – harrymc Aug 22 '11 at 19:53
Since no one else gave another possibility. I'll assume that's the only way to do it. Thanks @harrymc! – pablosaraiva Aug 26 '11 at 23:20
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.