Often it is Ctrl+ whatever is to the left of the 1 (number key)
was that the correct location.
I find a lot more use looking at a sample of the actual formulas in use
right on the spreadsheet. See
Show FORMULA or FORMAT of another cell
http://www.mvps.org/dmcritchie/excel/formula.htm
--
HTH,
David McRitchie
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
"Aeronav" wrote in message ...
Hi,
I got the answer : the shortcut is CTRL + "
Pingouin
"Aeronav" a écrit dans le message de ...
Hi,
I work in France, with an AZERTY keyboard, and I use Vista Home, french version, Excel french versions
Excel Help (2002, 2003, 2007) says that to display formulas instead of values (and back) I must hit CTR+ ` This second character
is what I can get when I hit AltGr+7. But trying to type AltGr + CTRL + 7 or CTRL+AltGr+7 does not do anything. I tried to switch
to a QWERTY keyboard (Alt + Shift for 3 seconds), this ` is now where I had the ² character, but CTRL + ² does no good. So back
to AZERTY...
I know how to make formulas appear (Options...) but a shortcut is much faster. Can anybody help me ?
Pingouin