Entering Data in Forms Using Commands

You can use these shortcuts in simple forms. Enter the keys or symbols, and then press Enter.

Table 4-2 Quick Data Entry Commands

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	Multiples the cell value by the percentage that you enter.	If the cell value is 100, entering per10 after 100 results in 10% of the current cell value, or 10.
Increase or inc	Increases the cell value by the percentage that you enter.	If the cell value is 200, entering inc10 after 200 increases the cell value by 10% of 200 (20), to 220.
Decrease or dec	Decreases the cell value by the percentage that you enter.	If the cell value is 200, entering dec10 after 200 decreases the cell value by 10% of 200 (20), to 180.
Power or pow	Changes the cell value to the number, added as an exponent.	If the cell value is 100, entering pow2 after 100 multiples the cell value by an exponent of 2, to 10,000.
gr	Grows a cell by a percentage.	If the cell value is 200, entering gr50 after 200 increases the cell value by 100, to 300.