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:
GR300: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.