Excel useful shortcut keys

Keys Combination	Action/Description
ALT+SHIFT+F1	Inserts a new worksheet.
SHIFT+F2	Adds/Edits a cell comment.
SHIFT+F3	Displays the Insert Function dialog box.
SHIFT+F6	Switches between the worksheet
SHIFT+F8	Enables you to add a nonadjacent cell.
ALT+F8	Displays the Macro dialog box to create.
SHIFT+F9	Calculates the active worksheet.
SHIFT+F10	Displays the shortcut menu for a selected item.
ALT+SHIFT+F10	Displays the menu or message for a smart tag.
SHIFT+F11	Inserts a new worksheet.
ALT+F11	Opens the Microsoft Visual Basic Editor
ARROW KEYS	Move one cell up, down, left, or right in a worksheet.
CTRL+ARROW KEY	Moves to the edge of the current data region in a worksheet.
SHIFT+ARROW KEY	Selection of cells by one cell.
CTRL+SHIFT+ARROW KEY	Selection of cells to the last nonblank cell in the same column or row.
BACKSPACE	Clears the content of the active cell
DELETE	Remove the cell content
CTRL+END	Moves to the last cell on a worksheet
CTRL+SHIFT+END	Selection of cells to the last used cell on the worksheet.
ENTER	Completes a cell entry and selects the cell below.
ALT+ENTER	Starts a new line in the same cell.
SHIFT+ENTER	Completes a cell entry and selects the cell above.
ESC	Cancels an entry in the cell.
HOME	Moves to the beginning of a row.
CTRL+HOME	Moves to the beginning of a worksheet.
CTRL+SHIFT+HOME	Selection of cells to the beginning of the worksheet.
PAGE DOWN	Moves one screen down in a worksheet.
ALT+PAGE DOWN	Moves one screen to the right in a worksheet.
CTRL+PAGE DOWN	Moves to the next sheet in a workbook.
CTRL+SHIFT+PAGE DOWN	Selects the current and next sheet in a workbook.
PAGE UP	Moves one screen up in a worksheet.
ALT+PAGE UP	Moves one screen to the left in a worksheet.
CTRL+PAGE UP	Moves to the previous sheet in a workbook.
CTRL+SHIFT+PAGE UP	Selects the current and previous sheet in a workbook.
SPACEBAR	One space, selects or clears a check box.
CTRL+SPACEBAR	Selects an entire column in a worksheet.
SHIFT+SPACEBAR	Selects an entire row in a worksheet.
CTRL+SHIFT+SPACEBAR	Selects the entire worksheet.
ALT+SPACEBAR	Displays the Control menu for the Microsoft Office Excel window.
TAB	Moves one cell to the right in a worksheet.
SHIFT+TAB	Moves to the previous cell in a worksheet
CTRL+TAB	Switches to the next tab in dialog box.
CTRL+SHIFT+TAB	Switches to the previous tab in a dialog box.