1)Use the arrow keys to select the first cell of the range
2)Hold down the [Shift] key while you extend the selection using the
up,
down, left, right arrow keys.
3)After the range is selected, and while still holding down the [Shift]
key,
press the [F8] key (they release all keys). You will see the word 'ADD'
in
the lower right of the status bar.
Repeat above steps until done selecting non-contiguous ranges.
Does that help?
Regards,
Ron
:
does anyone know the keyboard command used to select a range of nonadjacent
cells?Another option (especially useful if there are only a few cells to