Excel - I can't select nonadjacent cells

Asked By GESinOrego on 03-Nov-08 09:35 PM
I can select adjacent cells by click & drag.  But when holding down 'cntl'
and moving the cursor to the next bunch of cells, when clicked, the first
cell shows a single box and the previous selection disappears.  And I can't
drag to select any more cells.

What's the problem?  I've reloaded Excel twice, and no change.


="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" replied on 03-Nov-08 10:47 PM
Do this test...
Click and drag on a contiguous area.
Then press CTRL and click and drag over another area...
Both should be selected.

To test Type 1 and press CTRL-ENTER, both the areas should be filled by 1
Press CTRL-Z to undo.

If this fails then press CTRL and randomly click on cells
Type 1 and press CTRL-ENTER

Let us know.