Spreadsheets viewing formulas [Solved/Closed]

Report
Posts
1
Registration date
Friday May 19, 2017
Status
Member
Last seen
May 19, 2017
-
Posts
2669
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2020
-
How do I view hidden formulas on spreadsheet

1 reply

Posts
2669
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2020
446
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Hi TrowaD

I think you mean Ctrl ` (the button above the Tab key with the ~ on it)
Ctrl t is create a table.
Posts
2669
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2020
446
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.