• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. Customizing Excel > Common Problems and Solutions

Common Problems and Solutions

You can run into a couple of different problems when modifying Excel's menus and toolbars. You can also use the Options dialog box in Excel to solve certain problems. In the following sections, some common problems encountered in this area are discussed, along with their solutions.

Displaying Formulas to Audit a Workbook

On the View tab of the Options dialog box is a setting named Formulas. Selecting this setting causes your worksheets to display their formulas, instead of the results of the formulas. Printing the workbook with this option selected also prints a version that shows all of the formulas in the cells. Figure 8.19 shows a worksheet displayed using this option.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint