The microsoft online documentation for Desktop Excel misleadingly cites the same shortcuts for French and English even when they have explicitly chosen to change them for linguistics reasons (Ctrl+R and Ctrl+D are Ctrl+D and Ctrl+B in French to match the translation of "right" and "down") or these shortcut are literally impossible to use on a French Keyboard.
The offending shortcut is the purported (at this point I'm not even confident this is an actual shortcut) [corrected: Ctrl+Shift+"] to paste the content from the immediately above cell, but on French keyboards the equivalent keystrokes already do other things (the quote marks is not a direct key on french keyboards):
- French-Canadian QWERTY (which I use): Ctrl+Shift+2, which seems to be doing something related to cell widths (certainly not Bold formatting, as Microsoft somehow claims).
- AZERTY: Ctrl+Shift+3, which I have NO idea what it's actually assigned to other than it gives me a "no corresponding cells" error message and Microsoft has the gall to pretend it's an alternative for Italics.
Normally I would use the shortcut customizer to check what the keystroke is... but that is only available in Microsoft Word. Does the [corrected: Ctrl+Shift+"] shortcut exists at all in the French version of Excel and if so what is it?
Edit
While the problem is stated accurately, I have badly misstated the intended shortcut. That shortcut, in English, is in fact ctrl+SHIFT+". This is even worse, however, because it is literally impossible to type the quote marks without the shift key in French.
The shortcut is labelled in English as "Copy the value from the cell above the active cell into the cell or the formula bar" and listed as Ctrl+Shift+Straight quotation mark (").
(I have also fixed my use of "Maj" for "Shift" in the above post. It's the same key, but I should obviously use its english name here)
1 Answer 1
While fumbling around the shortcut for bold text(1), I stumbled across the answer completely by chance:
Turns out it's Ctrl+B
I had previously encountered that as a different changed shortcut for Ctrl+D (Fill Down). Turns out that French Excel uses the same shortcut for both functions, but neither changes are documented in the Microsoft shortcut list that I linked to.
(1) A recurring problem as that shortcut is changed to Ctrl+G by Microsoft in French, but basically no one else changes shortcut based on language (even Microsoft is not consistent about it!).
You must log in to answer this question.
Explore related questions
See similar questions with these tags.
CTRLkey, theSHIFTstops becoming a modifier for whatever other key you hit next. i.e.CTRL+SHIFT+2is not the same asCTRL+"even thoughSHIFT+2is"