I can't select non adjacent cells using the control button

M

mustbesimple

For some reason I am having a terrible time selecting or highlighting a group
of cells and then using the control button and selecting another group of
cells
 
G

Gord Dibben

Are you selecting say A1:A3 then hold CTRL key and select D1:D3?

What occurs when you try?

How about hitting SHIFT + F8 then selecting A1:A3 and D1:D3?


Gord Dibben MS Excel MVP
 
K

KjenkinJC

I would really like to see an answer on this. I teach Excel and on rare
occassion Excel simply doesn't work in this regard. I have the student move
to another machine and do the same thing with the same Excel sheet and it
works! Seems to be a myster to me
 
M

Maurice Griswold

I am experiencing the same problem. My 2003 version is fine. It is strictly limited to my 2007 version...anyone help?



KjenkinJC wrote:

I would really like to see an answer on this.
08-Oct-09

I would really like to see an answer on this. I teach Excel and on rar
occassion Excel simply does not work in this regard. I have the student mov
to another machine and do the same thing with the same Excel sheet and i
works! Seems to be a myster to me

Previous Posts In This Thread:

I can't select non adjacent cells using the control button
For some reason I am having a terrible time selecting or highlighting a grou
of cells and then using the control button and selecting another group o
cells

Are you selecting say A1:A3 then hold CTRL key and select D1:D3?
Are you selecting say A1:A3 then hold CTRL key and select D1:D3

What occurs when you try

How about hitting SHIFT + F8 then selecting A1:A3 and D1:D3

Gord Dibben MS Excel MVP

I would really like to see an answer on this.
I would really like to see an answer on this. I teach Excel and on rar
occassion Excel simply does not work in this regard. I have the student mov
to another machine and do the same thing with the same Excel sheet and i
works! Seems to be a myster to me

EggHeadCafe - Software Developer Portal of Choice
Silverlight 3 WCF-Enabled CodeSnippet app with Amazon SimpleDb
http://www.eggheadcafe.com/tutorial...0d-068142bff1a9/silverlight-3-wcfenabled.aspx
 
M

Maurice Griswold

I can select non-adjacent cells in Excel 2003 using the control key and the mouse. I cannot do this in my 2007 version of excel. This is extremely exasperating. Any ideas?



KjenkinJC wrote:

I would really like to see an answer on this.
08-Oct-09

I would really like to see an answer on this. I teach Excel and on rar
occassion Excel simply does not work in this regard. I have the student mov
to another machine and do the same thing with the same Excel sheet and i
works! Seems to be a myster to me

Previous Posts In This Thread:

I can't select non adjacent cells using the control button
For some reason I am having a terrible time selecting or highlighting a grou
of cells and then using the control button and selecting another group o
cells

Are you selecting say A1:A3 then hold CTRL key and select D1:D3?
Are you selecting say A1:A3 then hold CTRL key and select D1:D3

What occurs when you try

How about hitting SHIFT + F8 then selecting A1:A3 and D1:D3

Gord Dibben MS Excel MVP

I would really like to see an answer on this.
I would really like to see an answer on this. I teach Excel and on rar
occassion Excel simply does not work in this regard. I have the student mov
to another machine and do the same thing with the same Excel sheet and i
works! Seems to be a myster to me

Control Key
I am experiencing the same problem. My 2003 version is fine. It is strictly limited to my 2007 version...anyone help?

EggHeadCafe - Software Developer Portal of Choice
Getting Better Information on Unhandled Exceptions In Managed Code
http://www.eggheadcafe.com/tutorial...f-5ff1e261144c/getting-better-informatio.aspx
 
C

Chip Pearson

The CTRL key works just fine in XL2007, as it did in XL2003. Perhaps
you just can't see the selected cells (the color is very light and
very difficult to see if there is some background color applied to a
cell).

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 

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

Top