Nonadjacent cell selections with the keyboard in Excel 2007
Selecting more than one cell range is a little more complicated with the keyboard than it is with the mouse. When using the keyboard, you alternate between anchoring the cell cursor and moving the cell cursor to select the cell range and unanchoring the cell cursor and repositioning it at the beginning of the next range.
To unanchor the cell cursor so that you can move it into position for selecting another range, press Shift+F8. This puts you in Add to Selection mode, in which you can move to the first cell of the next range without selecting any more cells. Excel lets you know that the cell cursor is
unanchored by displaying the Add to Selection indicator on the left side of the Status bar.
To select more than one cell range by using the keyboard, follow these general steps:
1) Move the cell cursor to the first cell of the first cell range that you want to select.
2) Press F8 to get into Extend Selection mode.
Move the cell cursor to select all the cells in the first cell range. Alternatively, hold the Shift key as you move the cell cursor.
3) Press Shift+F8 to switch from Extend Selection mode to Add to Selection mode.
The Add to Selection indicator appears in the Status bar.
4) Move the cell cursor to the first cell of the next nonadjacent range that you want to select.
5) Press F8 again to get back into Extend Selection mode and then move the cell cursor to select all the cells in this new range.
6) If you still have other nonadjacent ranges to select, repeat Steps 3, 4, and 5 until you select and add all the cell ranges that you want to use.
Related Articles