I’ve found myself in the situation where no matter where I moved my cursor, the selection was extended. This is usually because I accidentally hit the F8 key to enter Extended Selection mode. I don’t think I’ve ever used it on purpose.
However, in my never-ending quest to rid myself of the mouse, I used a feature I’ve never used before: Shift-F8 to enter Add mode. I had a list of five numbers and I wanted to see the sum of the first, third, and fifth numbers. Normally, I would use the Control key and the mouse to select the three cells, then read the SUM in the status bar.
To do this with just the keyboard, I found the Add mode, but I still don’t think I’m using it right. To get the below SUM, I did the following:
- Start in A2
- Press Shift-F8
- Arrow down to A4
- Press Shift-F8 to exit Add mode
- Press Shift-F8 again to reenter Add mode
- Arrow down to A6
- Read the sum
That double Shift-F8 key sequence can’t be the best way, but I’ll be damned if I could come up with a better one.