Spreadsheets viewing formulas [Solved/Closed]

Posts
1
Registration date
Friday May 19, 2017
Status
Member
Last seen
May 19, 2017
- - Latest reply: TrowaD
Posts
2559
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 12, 2019
- May 29, 2017 at 11:01 AM
How do I view hidden formulas on spreadsheet
See more 

1 reply

Posts
2559
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 12, 2019
370
0
Thank you
Hi Johncooke,

Not sure what a hidden formula is, but maybe you are looking for the Ctrl+t keyboard combo. It will let you view the formula instead of the result. Hit the combo again to change it back.

Best regards,
Trowa
Hi TrowaD

I think you mean Ctrl ` (the button above the Tab key with the ~ on it)
Ctrl t is create a table.
TrowaD
Posts
2559
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 12, 2019
370 -
Hi x,

That's strange. For me it is definitely Ctrl+t. Must be different Excel versions ... Just like I have to use ; as a seperator in formula's where most people have to use , for that.