Excel Hacks – Part 2

Alt + Ctrl + F9 Calculates All cells on All worksheets in All workbooks
Alt + Shift + F1 Inserts a new worksheet (before the active sheet) into the active workbook (Insert > Worksheet)
Alt + Shift + F2 Displays the (File > Save As) dialog box
Alt + Shift + F4 Closes all the workbooks (saving first) and exits Excel (File > Exit)
Alt + Shift + F10 Displays the drop-down menu for the corresponding smart tag
Alt + Shift + F11 Activates the Microsoft Script Editor window
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
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

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
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 
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 


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 

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 
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 
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
Ctrl + . Moves clockwise to the next corner within a selection

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 
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 
= Starts a Formula 
Arrow Keys Moves to the next cell in that direction
Enter Moves to the cell directly below 
Tab Moves to the next cell on the right (or unprotected cell) 
Home Moves to the first column in the current row 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s