Supported Keystrokes

Key/Key Combination

Description

Arrow Keys

Pressing an arrow key produces different effects depending on what object is selected and/or focused (highlighted) in the Spreadsheet control:

•If a cell is focused, pressing the Left, Up, Right, or Down key moves focus to the left, top, right, or bottom adjacent cell;

•If a cell range is selected, pressing the Left, Up, Right, or Down arrow key clears the selection and shifts focus by one cell in the respective direction;

•If the focused cell is located at the left, top, right, or bottom edge of the worksheet area, pressing the Left, Up, Right, or Down key does not move focus;

Del

Pressing the Del key destroys all cell objects within all selected areas.

End

Moves focus to a cell following the rightmost cell object within the same row. If there are no cell objects in this row, the focus is moved to its first (i.e., the leftmost) cell.

Enter / Shift+Enter

Pressing the Enter key or the Shift+Enter key combination produces different effects depending on what object is selected and/or focused in the Spreadsheet control:

•If a cell is focused within a worksheet, pressing the Enter key moves focus to the next (i.e., underlying) cell within the same column. If the last cell in a column is focused, the Enter key moves focus to the topmost cell in the next (i.e., the right adjoining) column. If the last cell in the last (i.e., the rightmost) column is focused, pressing the Enter key sets the focus to the top cell in the worksheet's leftmost column.

•If a cell range is selected, pressing the Enter key moves cell focus within the range's boundaries in the same manner as described above. In the case of multiple selected cell ranges, the Enter key consecutively moves cell focus through all selected areas in the ascending order of their indexes within the worksheet's collection of selections. 

Both the Enter key and the Shift+Enter key combination close an in-place cell editor accepting its current contents as a new cell value. The cell focus shifts identically to the cases described above. The Shift+Enter key combination moves focus identically to the Enter key but in the opposite direction.

Esc

If an in-place editor is open, pressing the Esc key closes it and discards its current value.

F2

Opens an in-place editor for the focused cell.

F9

Recalculates all formula expressions within the current spreadsheet document.

Home

Moves cell focus to the leftmost (i.e., the first) cell in the current row.

Page Down

Moves cell focus to the next cell containing data in the column below the current focus. If no data is present, moves cell focus to last row in the spreadsheet.

Page Up

Moves cell focus to the next cell containing data in the column above the current focus. If no data is present, moves cell focus to first row in the spreadsheet.

Tab / Shift+Tab

Pressing the Tab key or the Shift+Tab key combination produces different effects depending on what object is selected and/or focused in the Spreadsheet control:

•If a cell is focused within a worksheet, pressing the Tab key moves focus to the next (i.e., the right adjoining) cell within the same row. If the last cell in a row is focused, the Tab key moves focus to the first cell on the next (i.e., the lower adjacent) row. If the last cell in the last row is focused, pressing the Tab key sets the focus to the first cell in the worksheet's topmost row.

•If a cell range is selected, pressing the Tab key moves the cell focus within the range's boundaries in the same manner as described above. In the case of multiple selected cell ranges, the Tab key consecutively moves the cell focus through all selected areas in the ascending order of their indexes within the active Table View worksheet's collection of selections.

•Both the Tab key and the Shift+Tab key combination close an in-place cell editor, accepting its current contents as a new cell value. The cell focus shifts identically to the cases described above. 

The Shift+Tab key combination moves focus identically to the Tab key but in the opposite direction.

Alt+Enter

When editing the contents of a cell, starts a new line within the open in-place cell editor.

Ctrl+;

Enters the current date into the focused cell.

Ctrl+`

With a cell in edit mode, switches between displaying formula expressions and their calculated results in the active worksheet.

Ctrl+'

Copies the formula expression to the focused cell from the adjacent cell above.

Ctrl+1

Displays the Format Cells dialog for the current cell selection.

Ctrl+2 / Ctrl+B

Adds/removes the bold attribute to/from the font used to display the contents of the current cell selections.

Ctrl+3 / Ctrl+I

Adds/removes the italic attribute to/from the font used to display the contents of the current cell selections.

Ctrl+4 / Ctrl+U

Adds/removes the underline attribute to/from the font used to display the contents of the current cell selections.

Ctrl+5

Adds/removes the strikeout attribute to/from the font used to display the contents of the current cell selections.

Ctrl+9

Hides all rows that intersect the current cell selection area.

Ctrl+0

Hides all columns that intersect the current cell selection area.

Ctrl+A

Selects all cells within the active worksheet.

Ctrl+Arrow Keys

Moves focus to the nearest cell object within the current row or column (i.e., the Ctrl+Left, Ctrl+Up, Ctrl+Right, or Ctrl+Down key combination moves focus to the nearest cell object located to the left, above, to the right, and below the currently focused cell). If there are no cell objects on the supposed path of the cell focus, it is moved to the last cell on the respective worksheet's edge (i.e., left, top, right, or bottom, depending on a specific arrow key pressed).

Ctrl+C / Ctrl+Insert

Copies the current cell selection to the clipboard. If there are multiple selections then the full area between the top left cell of those selections and the bottom right cell of the selections will be copied to the clipboard.

Ctrl+D

Populates the currently selected cell range with both the contents and style of its topmost cell (if the range's width does not exceed a single cell) or row.

Ctrl+End

Cancels the current cell selection and moves cell focus to the bottom-right corner of the Dimensions area. Previous cell focus position is irrelevant. If there are no cell objects within the active worksheet, pressing this key combination moves cell focus to the topmost cell in the worksheet's first column.

Ctrl+F

Invokes the Find and Replace dialog with the activated Find tab.

Ctrl+H

Invokes the Find and Replace dialog with the activated Replace tab.

Ctrl+Home

Cancels the current cell selection and moves the cell focus to the upper-left (origin) cell of the active worksheet.

Ctrl+K

Displays the Insert Hyperlink dialog for new hyperlinks or the Edit Hyperlink dialog for a previously created hyperlink. You can add hyperlinks to both the cells and floating containers, including comments.

Ctrl+Page Down

Switches between the currently visible worksheets, consecutively activating their respective tabs from left to right in the caption bar. If the rightmost worksheet tab is already active, pressing this key combination has no effect. The Ctrl+Page Up key combination consecutively activates the currently visible worksheets in reverse.

Ctrl+Page Up

Switches between the currently visible worksheets, consecutively activating their respective tabs from right to left in the caption bar. If the leftmost worksheet tab is already active, pressing this key combination has no effect. The Ctrl+Page Down key combination consecutively activates the currently visible worksheets in reverse.

Ctrl+R

Populates the currently selected cell range with both the contents and style of its leftmost cell (if the range's height does not exceed a single cell) or column.

Ctrl+Shift+7

Applies the outline border to the currently focused cell or selected cell range(s). This key combination is a direct counterpart of the Ctrl+Shift+_ key combination.

Ctrl+Shift+_

Returns the outline border of the currently focused cell or a selected cell range to its original state. This key combination is a direct counterpart of the Ctrl+Shift+& key combination.

Ctrl+Shift+~

Applies the General number format to data within the currently focused cell or selected cell range(s).

Ctrl+Shift+4

Applies the Currency number format to data within the currently focused cell or selected cell range(s).

Ctrl+Shift+5

Applies the Percentage number format to data within the currently focused cell or selected cell range(s).

Ctrl+Shift+6

Applies the Scientific number format to data within the currently focused cell or selected cell range(s).

Ctrl+Shift+3

Applies the Date number format to data within the currently focused cell or selected cell range(s).

Ctrl+Shift+2

Applies the Time number format to data within the currently focused cell or selected cell range(s).

Ctrl+Shift+1

Applies the Number format (that has two decimal places, thousands separator, and minus sign (-) for negative values) to the data within the currently focused cell or selected cell range(s).

Ctrl+Shift+8

Selects the current region around the focused cell (the area enclosed by blank rows and columns containing uninitialized cells).

Ctrl+Shift+:

Enters the current time into the focused cell.

Ctrl+Shift+“

Copies the value to the currently focused cell from the adjacent cell above.

Ctrl+Shift+End

Extends the selected cell range to the bottom-right corner of the Dimensions area, i.e., to the cell object with the largest row and column index values.

Ctrl+Shift+Enter

Accepts the changes made in an in-place cell editor and closes it, leaving the current cell focused. If an in-place editor was used to enter a formula expression, this key combination chooses the array formula variant of the function, if applicable.

Ctrl+Shift+Home

Extends the selected cell range to the active worksheet's upper-left cell.

Ctrl+Minus(–)

Displays the Delete dialog for deleting cells, rows, and columns at the currently focused cell or selected cell range.

Ctrl+Shift+O

Selects all cell objects that have an associated comment container in the currently active worksheet.

Ctrl+Plus(+)

Displays the Insert dialog for inserting cells, rows, and columns at the currently focused cell or selected cell range.

Ctrl+Spacebar

Selects an entire column whose cell object is currently focused. This key combination works even if there are no cell or column objects created within the active worksheet.

Ctrl+V / Shift+Insert

Pastes the current clipboard content into the active worksheet.

Ctrl+X / Shift+Del

Pressing this key combination results in moving (cutting) to the clipboard both the cell data and associated styles from the currently focused cell or a selected cell range.

Shift+Arrow Keys

This key combination expands the currently selected cell range by one cell, row, or column depending on the area's shape and the actual arrow key pressed. If there are several selected cell ranges within the active worksheet, this key combination expands only the last selected cell or cell range.

Shift+Spacebar

Selects the entire row that intersects the cell selection in which the cell focus is currently located.