WHEN IS CONTIGUOUS CONTIGUOUS?
Excel will let you select rows and columns of cells whether they be contiguous or noncontiguous. Let’s look at how this works. To check out Excel’s selection options, first open a new sheet. Now start at cell A1 and type 1, 2, 3, 4, 5 moving downward (that is, enter numbers in cells A1, A2, A3, A4, and A5. Repeat those entries in cells D1 through D5 and cells E15 through E19. Now use the mouse to select cells A1 through A5. Hold down Ctrl and use the mouse to select cells D1 through D5. Choose Edit, Copy. Go to cell F1 and press Ctrl-V. Excel will paste the values in the selected cells into cells F1 through F5 and G1 through G5. So there’s one use for the technique– you can eliminate unnecessary spaces between entries. Now use the mouse to select cells A1 through A5 again. Hold down Ctrl and select cells E15 through E19. If you now choose Edit, Copy, you’ll get an error message telling you that you can’t use the command on multiple selections. Obviously, this message isn’t entirely ac