Spreadsheets viewing formulas

Solved/Closed
johncooke Posts 1 Registration date Friday 19 May 2017 Status Member Last seen 19 May 2017 - 19 May 2017 à 06:32
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 29 May 2017 à 11:01
How do I view hidden formulas on spreadsheet
Related:

1 response

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
23 May 2017 à 11:49
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 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
29 May 2017 à 11:01
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.