I’m trying to put some German words in Excel and I need umlauts and other characters. I can use character map, but that’s a pain. Oh, and my laptop doesn’t have a number keypad so I can’t use the ascii codes (using the actual numbers doesn’t work). I even tried with the on screen keyboard and it won’t work. Is there any way to set up hotkeys or something to allow me to use a couple of key strokes to get the characters I need?
Whät ÖS änd vërsïön ärë yöü üsïng? Ön ä Mäc, yöü tÿpë ält-ü föllöwëd bÿ thë lëttër yöü wänt ït övër.
Are you using Windows? If so, you can go to the Control Panel or Settings (Time & Language) and open the Keyboard menu, which will allow you to add extra keyboard layouts, including German. Then you will be able to use the hotkeys Alt + Shift or Win + Space to switch layouts.
In my experience, notebook computers have a dedicated key that turns some of the standard QWERTY keyboard into a numeric keypad.
Or Spanish: any version of Spanish will do. The Spanish keyboard is QWERTY but the symbols you get on the shifted number keys and on the non-letter keys are different from the US and UK versions. The German keyboard is QWERTZ. To type any umlauted letter on the Spanish keyboard you use the following combination:
First, shift plus one of the keys on the right of your central row (it should be the rightmost one, but check it anyway): this will produce no character. Then you type the vowel and you get its umlauted version.
Type that first combination plus space: ¨
Type it followed by vowels instead of by space: äëïöü ÄËÏÖÜ
If you need acute accent ´ : the first key is the same without the shift. Grave accent ` is on the QWERTY row. Circumflex accent ^ is on the same key as the grave accent. All of them are typed on the same combination mechanism.
Add the United States International Keyboard layout (not sure what OS you are using, but possible in Windows). This does not change your basic keyboard at all except certain key sequences e.g. double-quote key followed by a vowel gets you an umlaut. Penalty is that if you want a double quote, then you need to hit the space bar to cancel the feature before you type the vowel.
You can get all sorts of international diacriticals etc. e.g. ú, õ, é, è
some instructions:
https://sites.psu.edu/symbolcodes/windows/codeint/
Or, on Mac, you can also hold down the letter you want modified for about a second and it will give you a menu of alternate form options (same thing happens on iOS devices like iPad and iPhone.) I’m guessing the OP has a Windows system, as that is presumably the default and I don’t think alt codes work on Mac–or at least if they do, I can’t get them to work. But I’ll put this tip out there in case it helps someone else who didn’t realize they could do this.
“Hey, pass me an umlaut!”
(old typesetters’ joke).
Huh, I’d never noticed that feature before-- Is it new? The last time I noticed holding down a letter doing something, it was just typing that letter repeatedlyyyyyyyyy.
Yeah well, Windows does have it as well… on touch screens, as does Android. Definitely not on physical keyboards.
Yeah, none of these worked for me. I’m on windows 10 on a notebook that doesn’t have a keypad. I tried the English international keyboard and the key combos that were suggested in the article, but they didn’t work.
turner, have you tried the foreign keyboard settings? You don’t need to have a keyboard with the proper symbols printed on it, just to change the settings. First thing I do on any keyboard I get is tell it “sorry dude, I know you think you’re American/British/German/French/Swiss/Italian but you’re actually International Spanish” and from then on I can touch-type normally.
Windows 10, Surface in tablet mode, onscreen keyboard set to United States International and the key sequences work fine.
Type cover keyboard works, as does an external Bluetooth keyboard.
Make sure you are set to the International keyboard (windows key+space)
öëïä
Press shift-’ (") followed by the letter you want.
(Win 10/US int keyboard)
éó (guess which combo that is)
ùìòèà (you’ve guessed it)
Because you are not the only one with this problem, it is acceptable to use an extra “e” in stead of an Umlaut. überhaupt becomes ueberhaupt, München Muenchen etc.
(It looks horrible, but it is better than just leaving the the dots off)
In Word (and presumably other MS Office applications), pressing Shift plus Ctrl plus : (at the same time), followed by the vowel you want to put the dots on top of, should do the trick.
Any idea if that works in excel? (I would try it myself, but I’m on a business trip and only have my tablet
Yup
i’ve found this page to be incredibly helpful… https://theasciicode.com.ar/