Turns on add mode, so you can select a second range without losing the first. Press Shift+F8, move to the next range with the arrow keys or the mouse, and select it. It is the keyboard version of Ctrl+click.
More Select shortcuts
- Turn extend selection mode on or offF8
- Extend the selection by one cellShift+Right
- Select the current region or the whole sheetCtrl+A
- Select the whole columnCtrl+Space
- Select one screen downShift+PageDown
- Select the whole rowShift+Space
- Select to the start of the sheetCtrl+Shift+Home
- Select to the last filled cellCtrl+Shift+Down
- Select to the last cell in useCtrl+Shift+End
- Select to the start of the rowShift+Home