Excel allows you to select non-contiguous ranges by chaining together multiple range references, eg C3:D4:E5:F6 is treated as selecting both C3:D4 and E5:F6 in a single reference. When a range ...