I can't select nonadjacent cells

  • Thread starter Thread starter GES in Oregon
  • Start date Start date
G

GES in Oregon

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.

gescott
 
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.
 
Back
Top