Sunday, 2 March 2014

Short Cuts 7

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


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



No comments:

Post a Comment