Select non-contiguous cells in Excel 2007

C

Compu Geek

How do I select non-contiguous cells in Excel 2007.

I tried using the ctrl button like I did in 2003, but it's not working.
 
G

Gord Dibben

Works for me.

What is it doing or not doing that leads you to believe it is "not working"?

How about if you hit SHIFT + F8 then select non-contiguous cells?


Gord Dibben MS Excel MVP
 
C

Compu Geek

You're Right!

The cells just don't show that they've been selected--as was the case in
2003. But, when I perform some task e.g. change the fill color, I can see
that they are all selected.

Is there a way to get the multiple non-contiguous cells to show that they
are selected? Is this occuring for all Excel 2007 users or is there something
crazy happening with just my version?
 
B

Bob I

The selected cells should have a light shading, it is not as dark as it
was in 2003 and some monitor settings make it difficult for the user to
see the selected cell. try increase monitor brightness and increase
monitor contrast to see the shading applied.
 

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

selecting non-contiguous cells 1
Copying puzzle 2
manually selected Excel cell formatting 1
Non-contiguous cells 2
Summing non contiguous cells 4
excel 2007 select multiple cells 1
Ctrl Key to Select Cells 1
Formula to define non-contiguous range? 7

Top