Quick data entry commands
Data entry commands are processed when you press Enter. These commands only apply to the current grid.
These commands are not case-sensitive.
You can use commands across two dimensions, but not across pages.
The following table lists the quick data entry commands.
| Command |
Description |
Action |
|---|---|---|
| K |
Enters the value in thousands. |
Example: 5K Enters 5,000 |
| M |
Enters the value in millions. |
Example: 10M Enters 10,000,000 |
| Add, + |
Adds a number to the cell value. |
Example: Add50 Adds 50 from the cell value |
| Subtract, Sub, ~ |
Subtracts a number from the cell value. Important: A minus sign (-) is not permitted for subtract because this indicates a negative number. |
Example: sub8 Subtracts 8 from the cell value |
| Percent, per |
Multiplies the cell value by a number added as a percentage. |
Example: per5 Gives 5% of the original cell value |
| Increase, Inc |
Increases the cell value by a number added as a percentage. |
|
| Decrease, Dec |
Decreases the cell value by a number added as a percentage. |
Example: decrease6 Decreases the cell value by 6% |
| GR |
Grows cells by a percentage. |
Example: GR>150:10 Increases the value by 10 percent starting with a value of 150. |
| Hold, Hol, H, HC |
Holds the cell value from breakback calculations. HC holds the consolidated level. |
|
| Release, Rel, RH, RC |
Releases held cells. |
|
| RA |
Release all held cells. |