MS Excel Shortcut Key's

Shortcut key              Description

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

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

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

Shortcut key              Description

Ctrl + Shift + *          Selects the current region (surrounded by blank rows and columns)

Ctrl + *                       Selects the current region

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

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