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.
Shift + Arrow Keys
Extends the selection by one cell in that direction.
Shift + Home
Extends the selection to the first column.
Shift + Page Up
Extends the selection up one screen.
Shift + Page Down
Extends the selection down one screen.
Ctrl + Shift + Up Arrow
Extends the selection to the next non blank cell above in the same column.
Ctrl + Shift + Down Arrow
Extends the selection to the next non blank cell below in the same column.
Ctrl + Shift + Left Arrow
Extends the selection to the next non blank cell on the left.
Ctrl + Shift + Right Arrow
Extends the selection to the next non blank cell on the right.
Ctrl + Shift + End
Extends 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 + Home
Extends 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 Keys
Extends the selection to the next non-blank cell in that direction.
Alt + Shift + Page Up
Extends the selection left one screen.
Alt + Shift + Page Down
Extends the selection right one screen.

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