Extending

Shift + Arrow KeysExtends the selection by one cell in that direction.
Shift + HomeExtends the selection to the first column.
Shift + Page UpExtends the selection up one screen.
Shift + Page DownExtends the selection down one screen.
Ctrl + Shift + Up ArrowExtends the selection to the next non blank cell above in the same column.
Ctrl + Shift + Down ArrowExtends the selection to the next non blank cell below in the same column.
Ctrl + Shift + Left ArrowExtends the selection to the next non blank cell on the left.
Ctrl + Shift + Right ArrowExtends the selection to the next non blank cell on the right.
Ctrl + Shift + EndExtends the selection to the Last Used Cell on the worksheet. This will not work when the following option is ticked (Advanced, Lotus compatibility - transition navigation keys).
Ctrl + Shift + HomeExtends the selection to the beginning of the worksheet. This will not work when the following option is ticked (Advanced, Lotus compatibility - transition navigation keys). Does not work on all keyboards though.
End, Shift + Arrow KeysExtends the selection to the next non-blank cell in that direction.
Alt + Shift + Page UpExtends the selection left one screen.
Alt + Shift + Page DownExtends the selection right one screen.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext