Data spread keyboard shortcuts

The following tables include details for all spreading methods that you can use in Planning Analytics Workspace.

You can specify the direction for data spreading by using these codes:

Down

|

Up

^

Left

<

Right

>

The default data action is Replace. To specify subtract, use a tilde (~). Use a plus sign (+) to specify the Add data action.

The following list summarizes the spreading methods that you can use:

Proportional

P

Example:

P<>100

Proportionally spreads the value 100 to all leaf cells on the row of insertion, and replaces the existing cell values.

Equal spread

S

Example:

S+|^200

Equally spreads the value 200 to all leaf cells on the column of insertion, and adds the product of spreading to the existing cell values.

Repeat

R

Example:

R~<50

Subtracts the value 50 from all leaf cells to the left of the insertion point.

Clear

C

Example:

C|^<>

Clears values from all leaf cells in the view.

Percent change

P%

Example:

P%+|^<>10

Applies a percent change of 10% to all leaf values, adds the product to the existing cell values, and increments all leaves by 10%.

Repeat leaves

LR

Example:

LR+*2100

Adds 2100 to all leaves of the consolidation. If you omit *, it copies 2100 only to populated leaf cells.

Equal leaves

LS

Example:

LS500

Distributes 500 equally across populated leaves of a consolidation.

Straight line

SL

Example:

SL>100:200

Replaces all leaf values to the right of the point of insertion, with a start value of 100 and an end value of 200.

Can be used across a single row or column, but not across rectangular ranges.

Growth percentage

GR

Example:

GR|300:25

Applies a 25% growth percentage to the starting value of 300 and replaces all leaf values below the point of insertion.

Can be used across a single row or column, but not across rectangular ranges.