Ad Hoc Grid Keyboard Shortcuts and Quick Data Entry Commands

Keyboard Shortcuts

You can quickly move around an ad hoc grid with these shortcut keys:

Key or Key Combination	Result
Tab	Moves to the next cell in the row. When focus is on the last cell of a row, Tab moves to the first cell of the next row.
Shift+Tab	Moves to the previous cell in the row. When focus is on the first cell of a row, Shift+Tab moves to the last cell of the previous row.
Up Arrow, Down Arrow	Moves up or down within the same column to the previous or next row.
Right Arrow, Left Arrow	Moves to the next cell or previous cell in the row.
Ctrl+Home	Moves to the first cell in the grid.
Shift+End	Moves to the last cell of the first row of the grid.
Ctrl+End	Moves to the last cell in the grid.
Ctrl+Right Arrow	Moves to the last cell in the current row.
Ctrl+Left Arrow	Moves to the first cell in the current row.
Shift+Space	Selects the row.
Ctrl+Space	Selects the column.
Ctrl+Up Arrow	Moves to the top row of the column.
Ctrl+Down Arrow	Moves to the bottom row of the column.
Ctrl+Shift+Up Arrow	Selects the cells in the column starting from the current cell to the top row of the column.
Ctrl+Shift+Down Arrow	Selects the cells in the column starting from the current cell to the bottom row of the column.
Shift+Left Arrow	Selects a cell to the left of the current cell in the row each time Left Arrow is pressed until it reaches the start of the row.
Shift+Right Arrow	Selects a cell to the right of the current cell in the row each time Right Arrow is pressed until it reaches the end of the row.
Shift+Up Arrow	Selects a cell above the current cell in the column each time Up Arrow is pressed until it reaches the top of the column.
Shift+Down Arrow	Selects a cell below the current cell in the column each time Down Arrow is pressed until it reaches the bottom of the column.
Shift+Click	Selects multiple cells by holding the Shift key and then using the mouse to select cells from different columns or rows in the grid.

Commands for Quickly Entering Data

You can use these shortcuts to quickly enter data in ad hoc grids. Enter the keys or symbols, and then press Enter or Tab.

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.
/	Divides the cell value by a number.	If the cell value is 100, entering /2 after 100 results in 50.
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 per10 after 100 results in 10% of the current cell value, or 10.
Increase or inc	Increases the cell value by the percentage 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 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 multiplies 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.