Entering Data Quickly Using Commands
You can use these shortcuts in forms. Enter the keys or symbols, and then press Enter.
Table 4-2 Commands for Quickly Entering Data
Keys or Symbol | Result | Example |
---|---|---|
K | Enters the value in thousands. | Enter 5K for 5,000.
|
M | Enters the value in millions. | Enter 5M for 5,000,000.
|
Add or + | Adds a number to the cell value. | If the cell value is 100, entering Add10 after 100 results in 110.
|
Sub or ~ | Subtracts a number from the cell value. | If the cell value is 100, entering Sub10 after 100 results in 90.
|
Percent or per | Multiplies the cell value by the percentage you enter. |
If the cell value is 100, entering |
Increase or inc | Increases the cell value by the percentage you enter. |
If the cell value is 200, entering |
Decrease or dec | Decreases the cell value by the percentage you enter. |
If the cell value is 200, entering |
Power or pow | Changes the cell value to the number, added as an exponent. |
If the cell value is 100, entering |
gr | Grows a cell by a percentage. |
If the cell value is 200, entering |
Note:
These shortcuts are available only if you're accessing forms from the desktop.