I can't select nonadjacent cells


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.





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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question