Manoeuvring
Arrow Keys | Moves to the next cell in that direction. |
Ctrl + Tab | Moves to the next open workbook or window. |
Ctrl + Shift + Tab | Moves to the previous 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 | Toggles "End Mode". In end mode arrow keys move you to the first blank or non blank cell in that direction. You will see the text "End Mode" appear in the status bar. |
End, Home | Moves to the Last Used Cell on the active worksheet. This is only updated when the workbook is closed. |
Page Up | Moves to the previous screen of rows (one screen up). |
Page Down | Moves to the next screen of rows (one screen down). |
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 or end of formula bar. |
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 or one word to the left. |
Ctrl + Right Arrow | Moves to the last column in the current region or one word to the right. |
Ctrl + Page Up | Moves to the Previous Worksheet in the workbook. |
Ctrl + Page Down | Moves to the Next Worksheet in the workbook. |
Ctrl + Backspace | Moves to the display the active cell. |
Scroll Lock + Arrow Keys | Moves the workbook or window one cell in that 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 Up | Moves you up one screen (current selection unchanged). |
Scroll Lock + Page Down | Moves you down one screen (current selection unchanged). |
Arrow Keys Moves to the next cell in that direction. |
Ctrl + Tab Moves to the next open workbook or window. |
Ctrl + Shift + Tab Moves to the previous 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 Toggles "End Mode". In end mode arrow keys move you to the first blank or non blank cell in that direction. You will see the text "End Mode" appear in the status bar. |
End, Home Moves to the Last Used Cell on the active worksheet. This is only updated when the workbook is closed. |
Page Up Moves to the previous screen of rows (one screen up). |
Page Down Moves to the next screen of rows (one screen down). |
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 or end of formula bar. |
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 or one word to the left. |
Ctrl + Right Arrow Moves to the last column in the current region or one word to the right. |
Ctrl + Page Up Moves to the Previous Worksheet in the workbook. |
Ctrl + Page Down Moves to the Next Worksheet in the workbook. |
Ctrl + Backspace Moves to the display the active cell. |
Scroll Lock + Arrow Keys Moves the workbook or window one cell in that 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 Up Moves you up one screen (current selection unchanged). |
Scroll Lock + Page Down Moves you down one screen (current selection unchanged). |
Manoeuvring (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. |
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. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext