ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   what are the keyboard strokes to reveal formulas in a worksheet? (https://www.excelbanter.com/excel-worksheet-functions/209253-what-keyboard-strokes-reveal-formulas-worksheet.html)

Steve2788

what are the keyboard strokes to reveal formulas in a worksheet?
 
to be able to toggle between the values or formulas in the cells of a worksheet

thanks

Sheeloo[_3_]

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

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

"Steve2788" wrote:

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

thanks


Steve2788

what are the keyboard strokes to reveal formulas in a workshee
 
Thanks,

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

"Sheeloo" wrote:

CTRL-`

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

"Steve2788" wrote:

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

thanks


Sheeloo[_3_]

what are the keyboard strokes to reveal formulas in a workshee
 
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...

"Steve2788" wrote:

Thanks,

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

"Sheeloo" wrote:

CTRL-`

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

"Steve2788" wrote:

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

thanks



All times are GMT +1. The time now is 12:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com