Here's our Microsoft Office Tip for.. December 20, 2005
Click Here to see a complete list of all of our previously released Tips!
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).