I can't select nonadjacent cells

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
 
S

Sheeloo

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

Similar Threads

VIEWING adjacent/nonadjacent cells or cell ranges in Excel 2007 1
pasting content copied from nonadajacent cells 1
I cannot select nonadjacent cells in Excell Office XP SP2 2
Selecting multiple cells, I can't see the cells highlighted 1
Locked cells are still able to be selected with proper protection 1
CTRL+Left-Click for Copying Non-Adjacent Cells Not Working 2
Issue selecting nonadjacent cells 1
How do I select a range of cells in an Excel table using the mouse 1

Top