Controlling Navigation

Keyboard navigation is defined by VisualStat. You can customize the actions when user press the enter key. The following navigation keys are provided.

 

Key

Action

Enter

Valid data entry into the cell or the formula bar and select the next cell (default)

Escape

Cancels an entry in the cell or formula bar

Tab

Moves the active cell to the next column and wraps at the end of the row

Shift + Tab

Moves the active cell to the previous column and wraps at the end of the row

F2

Clears the active cell’s value

=

Begins editing formula

Ctrl+C or Ctrl+Insert

Copies the selection to the Clipboard

Ctrl+X or Shift+Delete

Cuts the selection to the Clipboard

Ctrl+V or Shift+Insert

Pastes the data and formatting from the Clipboard

Up arrow

Moves active cell up one row

Down arrow

Moves active cell down one row

Left arrow

Moves active cell left one column

Right arrow

Moves active cell right one column

Shift + Up arrow

Extends selection up one row

Shift + Down arrow

Extends selection down one row

Shift + Left arrow

Extends selection left one column

Shift + Right arrow

Extends selection right one column

Page Up

Moves active cell up one page of rows

Page Down

Moves active cell down one page of rows

Shift + Page Up

Extends selection up one page of rows

Shift + Page Down

Extends selection down one page of rows

Shift + Ctrl + Page Up

Extends selection left one page of columns

Shift + Ctrl + Page Down

Extends selection right one page of columns

Home

Moves active cell to the first cell in the row

End

Moves active cell to the last cell in the row

Shift + Home

Extends the selection to include the first column

Shift + End

Extends the selection to include the last column

Ctrl + Home

Moves active cell to first row, first column

Ctrl + End

Moves active cell to last row, last column

Shift + Ctrl + Home

Extends the selection to include the first cell

Shift + Ctrl + End

Extends the selection to include the last cell

Shift + space

Selects the current row

Ctrl + space

Selects the current column

Shift + Ctrl + space

Selects the current sheet