0

There seems to be a pretty significant bug in Excel concerning EU keyboards with an AltGr key that is used to access rather important symbols such as €, #, and @. It is simply impossible to type any of these symbols directly either in the cell or the formula bar. The irony of it being a Microsoft keyboard doesn't escape attention either.

Is there anyone that have solved this issue? I have a user that keeps on getting this problem. We have tried to reactivate the process by running C:\Windows\System32\ctfmon.exe but this didn't help.

The strange thing is that the AltGr button works when using Excel inside remote desktop app, and it works fine locally when not using Excel.

All help is appreciated.

spikey_richie
  • 9,575
Sh4rky
  • 1

2 Answers2

0

The AltGr key should work fine in Excel. However, the keyboard locale can sometimes be a problem and you can try switching from the current language to see if this helps.

Nonetheless, if this won't work for you, you can try one of the other work-arounds to get the same outcome. For example Ctrl + Alt should serve the same function as AltGr on Windows 10.

If this also won't work for you, you can always use Windows Alt Codes to type characters directly. For example, the € symbol can be entered using Alt + 0128 or the Copywrite symbol © is Alt + 0169

For a full map of alt codes have a look at alt-codes.net.

I hope that this helps.

spikey_richie
  • 9,575
Clinton
  • 805
0

Found out that the issue was when he used Excell local. No RDP or Remote Desktop app running, same issue.

He had the Bloomberg terminal install with excell addin. uninstalled this app and then the Alt-Gr was back.

The wierd thing is that when we got Bloomberg installed again, the Alt-Gr button is Still working. So root couse = still unknown, but possible related to the Bloomberg app.

Sh4rky
  • 1