what are the keyboard strokes to reveal formulas in a worksheet?

S

Steve2788

to be able to toggle between the values or formulas in the cells of a worksheet

thanks
 
S

Sheeloo

CTRL-`

that is CTRl key with ' (which is on the same key as ~, top-left corner of
the keyboard)
 
S

Steve2788

Thanks,

so simple when know, but spend long time trying to find out in other help
and reference areas.
 
S

Sheeloo

Yes, I know the feeling...

Look under 'Excel shortcut and function keys' in Excel HELP... I am sure you
will find something which you have forgotten and some you never paid any
attention too...
 
Top