2

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?

slhck
  • 228,104
pablosaraiva
  • 73

1 Answers1

2

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

harrymc
  • 480,290
  • 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