Designing Worksheets

Define worksheet options to control the way worksheet data displays.

  To define Worksheet options:

  1. Select Analysis, then Worksheet Settings.

  2. Select Worksheet options:

    • Scale Percentages

      Scales percentages on the worksheet to translate into the proper percentage format on the Account spreadsheet.

    • Automatically Calculate Worksheets

      Calculates worksheets whenever you enter data. Activates when you enter data and exit the cell. Without this option, you must manually refresh the report when you enter data.

  3. In Worksheets are scaled in, select a scale:

    • Default

      Uses the scale in the source entity.

    • Ones

      1.0 = 1

    • Thousands

      1.0 = 1,000

    • Millions

      1.0 = 1,000,000

    • Billions

      1.0 = 1,000,000,000

  4. Click OK.