• Statement of Cash Flows Worksheet
  • Using the Statement of Cash Flows Worksheet
  • Naming an analysis item
  • Specifying worksheet settings
  • Setting the view preferences
  • Formatting the worksheet
  • Accessing Working Papers worksheets and dialogs
  • Accessing worksheet sections
  • Configuring tables
  • Specifying table properties
  • Entering data into the tables

Formatting the worksheet

Financials provides options that enable you to control how the Statement of Cash Flows Worksheet is displayed.

What do you want to do?

• Increasing or decreasing paragraph indents
• Adding or removing underlines
• Displaying headings
• Resizing a table

Increasing or decreasing paragraph indents

All paragraphs within the template are managed by styles that have been customized by the template author. In any line in a financial statement area, you can increase or decrease the indentation, or style level, of the description column. The amount to indent is specified by the style defined for the column. A new style is applied to the paragraph when you increase or decrease the indent.

Procedure

1. Open the worksheet and select the Formatting tab.
2. Select the description column whose indenting is to be altered.
3. To increase the style level, click (Increase level).
4. To decrease the style level, click (Decrease level).

Results

The content indenting is altered.

Adding or removing underlines

In the Statement of Cash Flows Worksheet, you can specify underlining for any line in a table.

Procedure

1. Open the worksheet and select the Formatting tab.
2. Select the line that is to be underlined.

3. Click (Underline). The Underline dialog appears.

4. Click Select All to specify an underline for all columns, or click on the columns for which an underline is to be defined. Note: Unselected columns will have no underlines.
5. From the Underline Type drop-down, select the type of underline to use.
6. From the Line Color dialog, select the color for the underline.
7. From the Thickness dialog, select the thickness of the underline.
8. Select the Underline Skips check box if you want the underline to appear even if the line is skipped. This is useful if the skipped line is the line immediately preceding a subtotal or total.
9. Click OK.

Results

The specified underlining is applied to the line.

Displaying headings

In the Statement of Cash Flows Worksheet, you can specify whether table headings are to be displayed for each of the activities.

Procedure

1. Open the worksheet and select the Formatting tab.
2. Select the Headings check box to display the headings, or unselect it to hide them.

Results

The headings are displayed or hidden as specified.

Resizing a table

You can specify the point size of the font in which a table in the Statement of Cash Flows Worksheet is displayed. Columns automatically adjust to fit page width when smaller sizes are selected.

Procedure

1. Open the worksheet and select the Formatting tab.
2. Select the table to be resized.
3. From the (Resize table) drop-down, select one of the following:

Option	Description
Default	Use the default font size. The font size is dependent on the standard defined by the template author.
Small	Use a font size 10% smaller than the default.
Smaller	Use a font size 20% smaller than the default.

Results

The table is displayed in the specified font.