Jul 27 2010

Non-Contiguous Ranges in Microsoft Excel

Category: WindowsTeknovis @ 5:12 pm

I was going mad today trying to select a non-contiguous range in Microsoft Excel until I came across this tip:

Any range can be non-contiguous. All you do is, as you are selecting cells with the mouse, hold the Control key down. You will be able to select as many disjoint blocks of cells on one sheet as you like. All Excel ranges can only be on one sheet, so your non-contiguous blocks cannot be on separate sheets, and cannot span sheets.

It is taken from Excel’s Non-Contiguous Ranges.