IT:Comparison of shortcuts in English and Spanish
From Stiki
This is a comparison of a subset of the keyboard shortcuts in Excel 2003. The purpose of this is to illustrate that assigning a macro to a keyboard shortcut is particularly risky if your document is intended for international use (for example within a global corporation).
The dangerous shortcuts are those that are not used in your local version or Excel, but are used in the target foreign language. For example Ctrl+E is not used in Excel 2003 in English, and so is a suitable candidate for a macro shortcut. But in Spanish this is the commonly used 'select all' (seleccionar todo) command.
If you know that your product will only be used in a particular set of languages, then you could compare the shortcuts amongst those languages to find common unused combinations (such as Ctrl+M in both English and Spanish). You are more likely to find examples of these in the Ctrl+Shift+(letter) range.
But if your product is to be used internationally in many countries, or you do not have access to Excel in multiple languages, you are better off not assigning keyboard shortcuts to your macros. Alternative methods to call the macros in a user-friendly way are to add controls to the spreadsheet (such as a button) or to add new items to the menu bar that call your code.
| Key |
|---|
| Shortcut has the same effect in both languages |
| Shortcut has different effects in either language |
| Shortcut has an effect in one language, but not the other |
| Shortcut has no effect in both languages |
| Shortcut | Effect in English | Effect in Spanish | English equivalent to Spanish effect | |
|---|---|---|---|---|
| Ctrl+A | Select all | Abrir | (Open) | Ctrl+O |
| Ctrl+B | Bold | Buscar | (Find) | Ctrl+F |
| Ctrl+C | Copy | Copiar | (Copy) | Ctrl+C |
| Ctrl+D | Fill down | Rellenar la derecha | (Fill right) | Ctrl+R |
| Ctrl+E | Seleccionar todo | (Select all) | Ctrl+A | |
| Ctrl+F | Find | Fuente | (Font name) | Ctrl+Shift+F |
| Ctrl+G | Go to | Guardar | (Save) | Ctrl+S |
| Ctrl+H | Replace | |||
| Ctrl+I | Italic | Ir a | (Go to) | Ctrl+G |
| Ctrl+J | Rellenar abajo | (Fill down) | Ctrl+D | |
| Ctrl+K | Insert hyperlink | Cursivo | (Italic) | Ctrl+I |
| Ctrl+L | Create list | Reemplazar | (Replace) | Ctrl+H |
| Ctrl+M | ||||
| Ctrl+N | New | Negrita | (Bold) | Ctrl+B |
| Ctrl+O | Open | |||
| Ctrl+P | Imprimir | (Print) | Ctrl+P | |
| Ctrl+Q | Crear lista | (Create list) | Ctrl+L | |
| Ctrl+R | Fill right | |||
| Ctrl+S | Save | Subrayado | (Underline) | Ctrl+U |
| Ctrl+T | Tamaño | (Font size) | Ctrl+Shift+P | |
| Ctrl+U | Underline | Nuevo | (New) | Ctrl+N |
| Ctrl+V | Paste | Pegar | (Paste) | Ctrl+V |
| Ctrl+W | Close | Cerrar | (Close) | Ctrl+W |
| Ctrl+X | Cut | Cortar | (Cut) | Ctrl+X |
| Ctrl+Y | Redo | Repetir | (Redo) | Ctrl+Y |
| Ctrl+Z | Undo | Deshacer | (Undo) | Ctrl+Z |
