TC A.P.L (Adam) noticed that the user in Ahab's post must have been using Ctrl+' and not Ctrl+`. The actual shortcut is Ctrl+` (the button next to the "1" key instead of a single quote). Thanks Adam!
Cheers!
Sunday, July 31, 2011
Quick Tip: Viewing Formulas in Spreadsheets
Asker Lidiam recently had a problem with viewing the outputs of functions. Lidiam was only seeing the functions and not the outputs. This led me to believe that at some point Lidiam hit Ctrl+` on accident. This is the keyboard shortcut for viewing formulas. Ahab's post provides another method for viewing formulas. Simply click View>All formulas and you will see your formulas. Select this option again and you will see the formula output.
TC A.P.L (Adam) noticed that the user in Ahab's post must have been using Ctrl+' and not Ctrl+`. The actual shortcut is Ctrl+` (the button next to the "1" key instead of a single quote). Thanks Adam!
Cheers!
TC A.P.L (Adam) noticed that the user in Ahab's post must have been using Ctrl+' and not Ctrl+`. The actual shortcut is Ctrl+` (the button next to the "1" key instead of a single quote). Thanks Adam!
Cheers!
Subscribe to:
Post Comments (Atom)
No problem Ted.
ReplyDeleteMight be a good time to mention a handy (and reasonably new) feature in Spreadsheets where Ctrl+/ will show a pop-up of available keyboard shortcuts.