View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default Shortcut to display formulas ?

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