Microsoft Office Tutorials and References
In Depth Information
Showing Formulas in Cells
NOTE: These options are sheet specific. That means that if you turn off the gridlines on Sheet1,
they will still remain visible on the other sheets. Remember also that if your turn the gridlines off,
you can still draw borders around selected cells (see Chapter 5).
Showing Formulas in Cells
If you’ve constructed a workbook with lots of formulas, you may need to inspect the
formulas for mistakes, or at least review them to remind yourself exactly how you put the
worksheet together. With that in mind, you can tell Excel to show the formulas in their
cells instead of the results of those formulas.
To show the formulas in a particular worksheet’s cells, click File Options Advanced,
and then check the Show formulas in cells instead of their calculated results box in the Display
options for this worksheet area (see Figure 9–26).
Figure 9–26. Where to display worksheet formulas in their cells
Click OK. All your worksheet’s formulas will now appear in their cells, something like
Figure 9–27.
Figure 9–27. What you’ll see in the cell instead of the result
To turn this visual effect off, return to the Advanced area of the File tab and uncheck the
Show formulas in cells instead of their calculated results option.
Search JabSto ::

Custom Search