Spread Windows Forms 13.0 Product Documentation
Spread Windows Forms 13.0 Product Documentation / Developer's Guide / Managing Keyboard Interaction / Default Keyboard Navigation
In This Topic
    Default Keyboard Navigation
    In This Topic

    The default behavior for end-user keyboard action is summarized in these tables.

    Default Behavior on a Sheet

    The default behavior for end-user keyboard action on the sheet is summarized in this table.

    Key Code Action Action Name
    Escape If edit mode is on, previous cell value replaces new value and edit mode is turned off CancelEditing
    F2 If edit mode is on, clears the active cell value ClearCell
    Ctrl+C or Ctrl+Insert Copies the selection to the Clipboard ClipboardCopy
    Ctrl+X or Shift+Delete Cuts the selection to the Clipboard ClipboardCut
    Ctrl+V or Shift+Insert Pastes the data and formatting from the Clipboard ClipboardPasteAll
    F3 If edit mode is on, places the current date and time in a date-time cell DateTimeNow
    Ctrl + Shift + Home Extends the selection to include the first cell ExtendToFirstCell
    Shift + Home Extends the selection to include the first column ExtendToFirstColumn
    Shift + Home Extends the selection to include the first item in a list ExtendToFirstItem
    Ctrl + Shift + End Extends the selection to include the last cell ExtendToLastCell
    Shift + End Extends the selection to include the last column ExtendToLastColumn
    Shift + End Extends the selection to include the last item in a list ExtendToLastItem
    Shift + Right Arrow or Ctrl + Shift + Right Arrow Extends selection right one column by index ExtendToNextColumn
    Shift + Right Arrow or Ctrl + Shift + Right Arrow Extends selection right one column by visual ExtendToNextColumnVisual
    Shift + Down Arrow Extends selection down one row ExtendToNextItem
    Ctrl + Shift + Page Down Extends selection right one page of columns ExtendToNextPageOfColumns
    Shift + Page Down Extends selection right one page of items ExtendToNextPageOfItems
    Shift + Page Down Extends selection down one page of rows ExtendToNextPageOfRows
    Shift + Down Arrow or Ctrl + Shift + Down Arrow Extends selection down one row ExtendToNextRow
    Shift + Left Arrow or Ctrl + Shift + Left Arrow Extends selection left one column by index ExtendToPreviousColumn
    Shift + Left Arrow or Ctrl + Shift + Left Arrow Extends selection left one column by visual ExtendToPreviousColumnVisual
    Shift + Up Arrow Extends selection left one item ExtendToNextItem
    Ctrl + Shift + Page Up Extends selection left one page of columns ExtendToPreviousPageOfColumns
    Shift + Page Up Extends selection up one page of items ExtendToPreviousPageOfItems
    Shift + Page Up Extends selection up one page of rows ExtendToPreviousPageOfRows
    Shift + Up Arrow or Ctrl + Shift + Up Arrow Extends selection up one row ExtendToPreviousRow
    Ctrl + Home Moves active cell to first row, first column MoveToFirstCell
    Home Moves active cell to the first cell in the row MoveToFirstColumn
    Home Moves active cell to the first item in the list MoveToFirstItem
    Ctrl + End Moves active cell to last row, last column MoveToLastCell
    End Moves active cell to the last cell in the row MoveToLastColumn
    End Moves active cell to the last item in the list MoveToLastItem
    Right Arrow or Ctrl + Right Arrow Moves active cell right one column by index MoveToNextColumn
    Right Arrow or Ctrl + Right Arrow Moves active cell right one column MoveToNextColumnVisual
    Tab Moves the active cell to the next column and wraps at the end of the row. (The Tab key skips hidden columns automatically.) MoveToNextColumnWrap
    Down Arrow Moves to the next item in the list. MoveToNextItem
    Ctrl + Page Down Moves active cell right one page of columns MoveToNextPageOfColumns
    Page Down Moves down one page of items MoveToNextPageOfItems
    Page Down Moves active cell down one page of rows MoveToNextPageOfRows
    Down Arrow Moves active cell down one row MoveToNextRow
    Down Arrow or Ctrl + Down Arrow Moves active cell down one row MoveToNextRow
    Left row or Ctrl + Left Arrow Moves active cell left one column by index MoveToPreviousColumn
    Left Arrow or Ctrl + Left Arrow Moves active cell left one column by visual MoveToPreviousColumnVisual
    Shift + Tab Moves the active cell to the previous column and wraps at the end of the row. (The Tab key skips hidden columns automatically). MoveToPreviousColumnWrap
    Ctrl + Left Arrow Moves to previous item in the list MoveToPreviousItem
    Ctrl + Page Up Moves active cell left one page of columns MoveToPreviousPageOfColumns
    Page Up Moves up one page of items MoveToPreviousPageOfItems
    Page Up Moves active cell up one page of rows MoveToPreviousPageOfRows
    Up Arrow or Ctrl + Up Arrow Moves active cell up one row MoveToPreviousRow
    Ctrl + Y Moves active cell up one row Redo
    Ctrl + Home Scrolls to display the first cell ScrollToFirstCell
    Home Scrolls to display the first column ScrollToFirstColumn
    Ctrl + End Scrolls to display the last cell ScrollToLastCell
    End Scrolls to display the last column ScrollToLastColumn
    Right Scrolls to display the next column by index ScrollToNextColumn
    Right Scrolls to display the next column by visual ScrollToNextColumnVisual
    Ctrl + Page Down Scrolls to display the next page of columns ScrollToNextPageOfColumns
    Page Down Scrolls to display the next page of rows ScrollToNextPageOfRows
    Down Scrolls to display the next row ScrollToNextRow
    Left Scrolls to display the previous column by index ScrollToPreviousColumn
    Left Scrolls to display the previous column by visual ScrollToPreviousColumnVisual
    Ctrl + Page Up Scrolls to display the previous page of columns ScrollToPreviousPageOfColumns
    Page Up Scrolls to display the previous page of rows ScrollToPreviousPageOfRows
    Up Arrow Scrolls to display the previous row ScrollToPreviousRow
    Ctrl + spacebar Selects the column containing the active cell SelectColumn
    Home Selects the first item in the list SelectFirstItem
    End Selects the last item in the list SelectLastItem
    Down Selects the next item in the list SelectNextItem
    Page Down Selects the next page of items in the list SelectNextPageOfItems
    Up Arrow Selects the previous item in the list SelectPreviousItem
    Page Up Selects the previous page of items in the list SelectPreviousPageOfItems
    Shift + spacebar Selects the row containing the active cell SelectRow
    Ctrl + Shift + spacebar Selects the current sheet SelectSheet
    F4 If edit mode is enabled in a date cell, spreadsheet displays a pop-up calendar to let you choose a date.

    If the edit mode is enabled in a formula text box or in a cell containing formula and a cell reference or range is selected, pressing the F4 key will show up various combinations of absolute and relative references.

    For example, let's say you have entered a formula "=A1" in a cell. Now, everytime the F4 key is pressed, the formula will change as per this cycle : A1 -> $A$1 -> A$1 -> $A1 -> A1

    ShowSubEditor                


    SwitchReferenceType

    Enter or Backspace Begins editing; stops editing if edit mode is on. StartEditing or StopEditing
    = Begins editing formula StartEditingFormula
    Alt + = Calculates sum of rows and/or columns. AutoSum
    Ctrl + Z Moves active cell up one row Undo
    Ctrl + 1 Shows the Number tab in the "Format Cells" dialog.    

    Ctrl + SHIFT + F or

    Ctrl + SHIFT + P

    Shows the Font Tab in the "Format Cells" dialog.    
    Ctrl + SHIFT + 1 Formats the selected cells as Number with 2 decimal places and thousands separator.  
    Ctrl + SHIFT + 3 Formats the selected cells as Date in the format 'd-mmm-yy'.  
    Ctrl + SHIFT + 4 Formats the selected cells as currency (upto 2 decimal places, separator, negative red, parenthesis around negative).  
    Ctrl + SHIFT + 5 Formats the selected cells as percentage (upto 0 decimal places).  
    Ctrl +  ; Inserts the current date in the cell. Also, this is the default short date format for culture.  
    Ctrl + SHIFT + : Inserts the current time in the cell. Also, this is the default short time format for culture.  
    Ctrl + 9 Hides the current selected row. This action can't be undone.  
    Ctrl + 0 Hides the current selected column. This action can't be undone.  
    Ctrl + - Deletes the current selected column, row or cells. This action can't be undone.  
    Ctrl + ` Can be used to toggle between displaying formulas in cells and displaying calculated values in cells.  
    SHIFT + F11 Inserts a new worksheet in the workbook.  
    Ctrl + PAGEUP Navigates to the previous worksheet in the workbook.  
    Ctrl + PAGEDOWN Navigates to the next worksheet in the workbook.  
    Ctrl + END Navigates to the last data cell in the worksheet.  
    Ctrl + T Inserts a table for the selected range of cells.  
    Ctrl + D Fills down the data from the first cell to the selected empty cells after selecting a cell with data and then selecting a range of contiguous empty cells below that cell.  
    Ctrl + R Fills the data in the right direction from the first cell to the selected empty cells after selecting a cell with data and then selecting a range of contiguous empty cells to the right of that cell.  
    Ctrl + SHIFT + L Toggles the filter buttons in the active worksheet filter range or table.  

    Keyboard navigation is defined by default maps, that map user keyboard actions with Spread component actions. For example, by default, pressing Tab moves the active cell to the next column. You can customize any or all of the keyboard actions by mapping them to Spread component actions.

    The built-in keyboard actions (for example, MoveToNextRowWrap) treat a cell span as existing in both columns or rows. You can enter the span by navigating down either column or row. When leaving the span in a backwards direction (for example, MoveToPreviousRowWrap), the built-in action uses the upper left corner of the span for computing the previous column or row. When leaving the span in a forwards direction (for example, MoveToNextRowWrap), the built-in action uses the lower right corner of the span for computing the new column or row.

    For the Ctrl+PageUp and Ctrl+PageDown keys, if you want your application to mimic the behavior found in Excel (that is, move left or right one sheet regardless of number of sheets) then rebind the keystrokes to the MoveToPreviousSheet and MoveToNextSheet actions.

    Actions that extend, move, or scroll to the next or previous column use the visual layout of the screen by default. The previous column is a column that is visually left of the active column and the next column is column that is visually right of the active column. In Spread Windows Forms 2.5, cell coordinates were used. In cell coordinates, the previous column is the active column - 1 and the next column is the active column + 1. The cell coordinate actions are still available and are listed in the SpreadActions class.

    Default Behavior for Shapes on a Sheet

    The default navigation keys for shapes on a sheet are used with all operation modes and can be changed with the SetInputMapWhenShapeHasFocus method. The default navigation keys for shapes are listed in the following table.

    Key Code Action Action Name
    Tab Moves to next shape ActivateNextShape
    Shift + Tab Moves to previous shape ActivatePreviousShape
    Ctrl + C or Ctrl + Insert Copies shape ClipboardCopyShape
    Ctrl + X or Shift + Delete Cuts shape ClipboardCutShape
    Ctrl + V or Shift + Insert Pastes shape ClipboardPasteShape
    N/A Cuts data only ClipboardCutDataOnly
    Escape Deactivates shape DeactivateShape
    Ctrl + Up Arrow Decreases shape height DecreaseShapeHeight
    Ctrl + Left Arrow Decreases shape width DecreaseShapeWidth
    Delete Deletes shape DeleteShape
    Ctrl + Down Arrow Increases shape height IncreaseShapeHeight
    Ctrl + Right Arrow Increases shape width IncreaseShapeWidth
    Down Arrow Moves shape down MoveShapeDown
    Left Arrow Moves shape left MoveShapeLeft
    Right Arrow Moves shape right MoveShapeRight
    Up Arrow Moves shape up MoveShapeUp
    Alt + Right Arrow Rotates shape clockwise RotateShapeClockwise
    Alt + Left Arrow Rotates shape counter-clockwise RotateShapeCounterClockwise

    For more information about shapes, refer to Customizing Drawing.

    Default Behavior for Child Controls on a Sheet

    The default navigation keys for child controls on a sheet are used with all operation modes and can be changed with the SetInputMapWhenChildHasFocus method. The default navigation keys for child controls on a sheet are listed in the following table.

    Key Code Action Action Name
    Tab Moves to next control ActivateNextChild
    Shift + Tab Moves to previous control ActivateNextShape
    Escape Deactivates control DeactivateChild
    Ctrl + Up Arrow Decreases control height DecreaseChildHeight
    Ctrl + Left Arrow Decreases control width DecreaseShapeWidth
    Delete Deletes control DeleteChild
    Ctrl + Down Arrow Increases control height IncreaseChildHeight
    Ctrl + Right Arrow Increases control width IncreaseChildWidth
    Down Arrow Moves control down MoveChildDown
    Left Arrow Moves control left MoveChildLeft
    Right Arrow Moves control right MoveChildRight
    Up Arrow Moves control up MoveChildUp

    For more information about controls, refer to Placing Child Controls on a Sheet.