Google
 

Tuesday, October 23

Toggling Between Views

Displaying the results of formulas is a view default. You can easily display the formulas instead of those results by choosing Tools, Options. Then, select the View tab and choose the Formulas option in the Windows Options section.
Do you know there's a keyboard shortcut that will toggle a sheet between displaying formulas and the results of those values? It's great when you need to switch back and forth quickly instead of remaining in one view. Simply press Ctrl-` (to the left of the 1 key).
Google