Entering Data
Enter Enters the contents of the active cell and moves to the cell below (by default)
Shift + Enter Enters the contents of the active cell and moves to the cell above (by default)
Tab Enters the contents of the active cell and moves one cell to the right
Shift + Tab Enters the contents of the active cell and moves one cell to the left
Alt + = Enters the SUM() function (AutoSum) to sum the adjacent block of cells
Alt + 0128 Enters the euro symbol (€) (using Number keypad)
Alt + 0162 Enters the cent symbol (¢) (using Number keypad)
Alt + 0163 Enters the pound sign symbol (£) (using Number keypad)
Alt + Enter Enters a new line (or carriage return) into a cell
Ctrl + ‘ Enters the contents from the cell directly above into the active cell
Ctrl + Shift + 2 Enters the value from the cell directly above into the active cell
Ctrl + ; Enters the current date into the active cell
Ctrl + Shift + ; Enters the current time into the active cell
Ctrl + Shift + Enter Enters the formula as an Array Formula
Shift + Insert Enters the data from the clipboard
Alt + Down Arrow Displays the Pick From List drop-down list Esc Cancels the cell entry and restores the original contents
Editing Data
Delete Deletes the selection or one character to the right
Backspace Deletes the selection or one character to the left Shift + Delete Cuts the selection to the clipboard
Ctrl + Delete Deletes text to the end of the line Ctrl + – Displays the Delete dialog box
Ctrl + Shift + = Displays the Cells dialog box
Selecting Data
Ctrl + Selects the cells in a selected row that do not match the value in the active cell
Ctrl + Shift + Selects the cells in a selected column that do not match the value in the active cell
Ctrl + / Selects the array containing the active cell ??
Alt + ; Selects the visible cells in the current selection
Ctrl + Shift + (8 or *) Selects the current region (surrounded by blank rows and columns)
Ctrl + * Selects the current region (using the * on the number keyboard)
Ctrl + [ Selects all the cells that are directly referred to by the formula in the active cell (precedents)
Ctrl + Shift + [ Selects all the cells that are directly (or indirectly) referred to by the formula in the active cell
Ctrl + ] Selects all the cells that directly refer to the active cell (dependents)
Ctrl + Shift + ] Selects all the cells that directly (or indirectly) refer to the active cell
Ctrl + Shift + Page Down Selects the active worksheet and the one after it
Ctrl + Shift + Page Up Selects the active worksheet and the one before it
Ctrl + Shift + Spacebar Selects all the objects on the worksheet when an object is selected or selects the whole worksheet
Ctrl + Spacebar Selects the current column
Shift + Arrow keys Selects the active cell and the cell in the given direction
Shift + Backspace Selects the active cell when multiple cells are selected
Shift + Spacebar Selects the current row
Extending Data
Ctrl + Shift + Arrow Key Extends the selection to the next cell adjacent to a blank cell in that direction
Ctrl + Shift + End Extends the selection to the last used cell on the worksheet
Ctrl + Shift + Home Extends the selection to the beginning of the worksheet
Shift + Arrow Keys Extends the selection by one cell in that direction
Shift + Home Extends the selection to the first column
Shift + Page Down Extends the selection down one screen
Shift + Page Up Extends the selection up one screen
End + Shift + Arrow Keys Extends the selection to the next non-blank cell in that direction
End + Shift + End Extends the selection to the last cell in the current row*
End + Shift + Home Extends the selection to last used cell on the worksheet