Spreadsheets viewing formulas

Solved/Closed
johncooke
Posts
1
Registration date
Friday May 19, 2017
Status
Member
Last seen
May 19, 2017
- May 19, 2017 at 06:32 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- May 29, 2017 at 11:01 AM
How do I view hidden formulas on spreadsheet

1 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
May 23, 2017 at 11:49 AM
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
1
Hi TrowaD

I think you mean Ctrl ` (the button above the Tab key with the ~ on it)
Ctrl t is create a table.
0
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
May 29, 2017 at 11:01 AM
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.
0