Sunday, 2 March 2014

Short Cuts 8

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


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


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


Alt Toggles the activation of the old Menu Bar


Alt + Shift + Left Arrow Displays the (Data > Group and Outline > UnGroup) dialog box


Alt + Shift + Right Arrow Displays the (Data > Group and Outline > Group) dialog box


Alt + Spacebar Activates the Control Box in the top left hand corner


End Toggles between switching End Mode on or off


Scroll Lock Toggles between switching Scroll Lock on or off


Shift + Insert Pastes the entry from the clipboard


No comments:

Post a Comment