Manoeuvring

Arrow KeysMoves to the next cell in that direction.
Ctrl + TabMoves to the next open workbook or window.
Ctrl + Shift + TabMoves to the previous open workbook or window.
Alt + TabMoves to the next application open on your computer.
Alt + Shift + TabMoves to the previous application open on your computer.
EnterMoves to the cell directly below.
TabMoves to the next cell on the right (or unprotected cell).
HomeMoves to the first column in the current row.
End, Arrow KeysMoves to the next non empty cell in that direction.
End, EnterMoves to the last cell in the current row that is not blank.
EndToggles "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, HomeMoves to the Last Used Cell on the active worksheet. This is only updated when the workbook is closed.
Page UpMoves to the previous screen of rows (one screen up).
Page DownMoves to the next screen of rows (one screen down).
Shift + EnterMoves to the cell directly above (opposite direction to Enter).
Shift + TabMoves to the cell directly to the left (opposite direction to Tab).
Alt + Page DownMoves you one screen of columns to the right.
Alt + Page UpMoves you one screen of columns to the left.
Ctrl + HomeMoves to cell "A1" on the active sheet.
Ctrl + EndMoves to the Last Used Cell on the active worksheet or end of formula bar.
Ctrl + Up ArrowMoves to the first row in the current region.
Ctrl + Down ArrowMoves to the last row in the current region.
Ctrl + Left ArrowMoves to the first column in the current region or one word to the left.
Ctrl + Right ArrowMoves to the last column in the current region or one word to the right.
Ctrl + Page UpMoves to the Previous Worksheet in the workbook.
Ctrl + Page DownMoves to the Next Worksheet in the workbook.
Ctrl + BackspaceMoves to the display the active cell.
Scroll Lock + Arrow KeysMoves the workbook or window one cell in that direction.
Scroll Lock + EndMoves to the last cell in the current window.
Scroll Lock + HomeMoves to the first cell in the current window.
Scroll Lock + Page UpMoves you up one screen (current selection unchanged).
Scroll Lock + Page DownMoves 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)

EnterMoves from top to bottom within a selection.
TabMoves from left to right within a selection.
Ctrl + .Moves clockwise to the next corner within a selection.
Shift + TabMoves from right to left within a selection (opposite direction to Tab).
Alt + Ctrl + Left ArrowMoves to the left between non adjacent cells in a selection.
Alt + Ctrl + Right ArrowMoves 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