Question

select the tow non .contiguous ranges (not next​

Answer 1

Answer:

Just press and hold down the Ctrl key, and you can select multiple non-adjacent cells or ranges with mouse clicking or dragging in active worksheet. This does not require holding down keys during selection