EXCEL SHORTCUTS KEYS

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
 EXCEL SHORTCUTS KEYS
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
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
 EXCEL SHORTCUTS KEYS
Alt + ‘ = Displays the Style dialog box
Ctrl + Shift + ( ' or ) = Applies the Time format "hh:mm" to the selection
Ctrl + Shift + (1 or !) = Applies the Comma separated format "#,##0.00" to the selection
Ctrl + Shift + (4 or $) = Applies the Currency format "£#,##0.00" to the selection
Ctrl + Shift + (5 or %) = Applies the Percentage format "0%" to the selection
Ctrl + Shift + (6 or ^) = Applies the Exponential format "#,##E+02" to the selection
Ctrl + Shift + (# or ~) =Applies the General format to the selection
Ctrl + (# or ~) = Applies the Custom Date format "dd-mmm-yy" to the selection
Ctrl + Shift + (7 or &) = Applies the outline border to the selection
Ctrl + Shift + (- or _ ) =Removes all the borders from the selection
Arrow Keys = Moves to the next cell in that direction
Ctrl + Tab = Moves to the next open workbook or window
Alt + Tab = Moves to the next application open on your computer
Alt + Shift + Tab = Moves to the previous application open on your computer
Enter = Moves to the cell directly below
 EXCEL SHORTCUTS KEYS
Tab = Moves to the next cell on the right (or unprotected cell)
Home = Moves to the first column in the current row
End + Arrow Keys = Moves to the next non empty cell in that direction
End + Enter = Moves to the last cell in the current row that is not blank
End + Home = Moves to the last used cell on the active worksheet*
End + Home = Moves to the last used cell on the active worksheet*
Page Down = Moves to the next screen of rows down
Page Up = Moves to the previous screen of rows up
Shift + Enter = Moves to the cell directly above (opposite direction to Enter)
Shift + Tab = Moves to the cell directly to the left (opposite direction to Tab)
Alt + Page Down = Moves you one screen of columns to the right
Alt + Page Up = Moves you one screen of columns to the left
Ctrl + Home = Moves to cell "A1" on the active sheet
Ctrl + End =Moves to the last used cell on the active worksheet*
Ctrl + Up Arrow = Moves to the first row in the current region
 EXCEL SHORTCUTS KEYS
Ctrl + Down Arrow = Moves to the last row in the current region
Ctrl + Left Arrow = Moves to the first column in the current region
Ctrl + Right Arrow = Moves to the last column in the current region
Ctrl + Page Up = Moves to the previous worksheet in the workbook
Ctrl + Page Down = Moves to the next worksheet in the workbook
Ctrl + Shift + Tab = Moves to the previous open workbook or window
Scroll Lock + Arrow Keys = Moves the workbook or window one cell the corresponding direction
Scroll Lock + End = Moves to the last cell in the current window
Scroll Lock + Home = Moves to the first cell in the current window
Scroll Lock + Page Down = Moves you down one screen (current selection unchanged
Scroll Lock + Page Up = Moves you up one screen (current selection unchanged)
Enter = Moves from top to bottom within a selection
Tab = Moves from left to right within a selection
Ctrl + . = Moves clockwise to the next corner within a selection
 EXCEL SHORTCUTS KEYS
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
 EXCEL SHORTCUTS KEYS

Shift + Tab = Moves from right to left within a selection (opposite direction
to Tab)
Alt + Ctrl + Left = Arrow Moves to the left between non adjacent cells in a
selection
Alt + Ctrl + Right = Arrow Moves to the right between non adjacent cells in a
selection
Ctrl + ` = Toggles between the value layer and the formula layer
Ctrl + Insert = Copies the current selection to the clipboard
Ctrl + Shift + ( = Unhides any hidden rows within the selection
Ctrl + Shift + ) = Unhides any hidden columns within the selection
Ctrl + Shift + \ = Select unequal cells
Follow Me @Kiran Bharambe
for More Contents.