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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 29, 2017 at 11:01 AM
How do I view hidden formulas on spreadsheet

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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