Setting the view options

When working with the Segment Reporting Worksheet, you can set view options that control the display of the worksheet.

Prerequisites

To set view options in the Segment Reporting Worksheet, you must open the worksheet and select the Home tab.

Clearing the changed flags

If a value is changed in the Segment Reporting Worksheet, the changed value is marked with a changed flag, which is a red underline. You can specify that all of these changed flags are to be cleared.

Procedure

  1. Open the Segment Reporting Worksheet and select the Home tab
  2. Click (Clear Changed Flags).

Results

The changed flags are cleared.

Showing or hiding the annotation column

In the Segment Reporting Worksheet, you can show or hide the annotation column.

Procedure

  1. Open the Segment Reporting Worksheet and select the Home tab
  2. Click (Annotation column). This displays the annotation column if it is hidden, or hides it if it is displayed.

Results

The annotation column is displayed or hidden.

Viewing the worksheet balance warning

The Segment Reporting Worksheet can display a warning if the defined totals are not allocated across all segments. This is done by comparing the total to be allocated against the total amounts allocated by segment. You can turn this warning on or off.

Procedure

  1. Open the Segment Reporting Worksheet and select the Home tab
  2. Click (Warning). This displays the worksheet balance warning if it is hidden, or hides it if it is displayed.

Results

The worksheet balance warning is displayed or hidden.

Showing or hiding headings

You can specify whether to display or hide the headings that appear at the top of the Segment Reporting Worksheet.

Procedure

  1. Open the Segment Reporting Worksheet and select the Home tab
  2. Click (Headings). This displays the headings if they are hidden, or hides them if they are displayed.

Results

The headings are displayed or hidden.

Showing or hiding skipped rows or columns

In the Segment Reporting Worksheet, you can specify whether to show or hide rows or columns that have been skipped.

Procedure

  1. Open the Segment Reporting Worksheet and select the Home tab
  2. Click (Hide/skip rows/columns). This hides the skipped rows or columns.
  3. Click (Hide/skip rows/columns) again to display the skipped rows or columns again.

Results

The skipped rows or columns are hidden or displayed.