to be able to toggle between the values or formulas in the cells of a worksheet thanks
S Steve2788 Nov 6, 2008 #1 to be able to toggle between the values or formulas in the cells of a worksheet thanks
S Sheeloo Nov 6, 2008 #2 CTRL-` that is CTRl key with ' (which is on the same key as ~, top-left corner of the keyboard)
S Steve2788 Nov 6, 2008 #3 Thanks, so simple when know, but spend long time trying to find out in other help and reference areas.
Thanks, so simple when know, but spend long time trying to find out in other help and reference areas.
S Sheeloo Nov 6, 2008 #4 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...
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...