Extending
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. |
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. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext