Monday, January 7, 2019

12 Basic Shortcuts That Will Make You An Excel Guru And Add Hours To Your Life

There are 12 basic shortcuts that will make you an excel guru and add hours to your life.

Formatting Data



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



Maneuvering



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


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


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)



Maneuvering (within a selection)



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


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