I don’t want to insult anyone’s intelligence! I know that most of my subscribers already know how to see the formulas in the cells of their worksheet instead of the results of the formula.
I am also pretty sure you do this by following the steps below:
- Open the Excel Options dialog box in version 2007 by clicking the Office button and Excel Options. In version 2010, by clicking the File tab of your Ribbon and then Options.
- Click Advanced.
- Scroll down to Display Options for this Worksheet section.
- Be certain the Show Formulas in Cells Instead of their Calculated Result check box is selected.
- Click OK.
Isn’t that about right??
Well, as you all know, I just LOVE to save time and keystrokes so I am going to show you how to accomplish the above with a key combination! Ready?
Click CTRL +`
Voila! Done! For those of you who do not know that is after the plus sign above, it is an accent Grave and you can find it to the left of the number 1 key on your keyboard above the Tab key.